I have a table with a column is set as identity. now the application(c++ program, use ODBC) will insert vaules into the column, so I enable the identity_insert.
However, I found that the SQL server does not check the value inserted into that column, even the vaule exsits, this is a violation to the identity property. any way to prevent this? i.e. let SQL server check if the value exsits, if exsits, simply insert another value decided by the identity. Is it possible?