T-SQL INSERT Identity Column Errors

Verify the error message for mentions of IDENTITY_INSERT. This occurs when attempting to manually supply a value to a column configured as an auto-incrementing identity. Check the table definition using 'SP_HELP [table_name]' to see if the column has the 'identity' property set.

Sources