Msg 8106, Level 16, State 1, Line 1
Table ‘%1!’ does not have the identity property. Cannot perform SET operation.
This error message appears when you try to use the SET IDENTITY_INSERT setting for a table that does not contain a column, for which the IDENTITY property was declared.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity level 16 are generated by the user and can be fixed by the SQL Server user. The SET IDENTITY_INSERT setting cannot be used on such a table.
All versions of SQL Server.
CREATE TABLE t
SET IDENTITY_INSERT t ON
INSERT INTO t SELECT -1
SET IDENTITY_INSERT t OFF
DROP TABLE t
In the above example we try to turn on the IDENTITY_INSERT setting für the table t to insert an explicite value into a column for which the IDENTITY property was declared. Because there no such column in table t, the error is raised.