Error 8106

Troubleshooting SQL Server

Troubleshooting

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

SET IDENTITY_INSERT

sp_help