Error 8106

Severity Level 16

Message Text

Table '%.*ls' does not have the identity property. Cannot perform SET operation.

Explanation

You have attempted to use the SET IDENTITY_INSERT property on a table that does not contain an identity column.

Action

Double-check the table in question by using the sp_help tblName stored procedure to verify the identity column information.

See Also