I am performing "SET IDENTITY_INSERT ON" on a table which does not have IDENTITY COLUMN. It gives me an error because of that as follows.
Table does not have the identity property. Cannot perform SET operation.
How do i supress the error and proceed.
The error states that SQL Server does not think there is an identity column on the table. If there truly is then the Index relating to the identity is corrupt. You may be able to fix it with DBCC commands but your best bet is to change the identitiy field to a int, saving it and then changing it back to an identity. Its sort of like jury rigging a table. Microsoft will recommend dropping the table and recreating it.