Error message: Cannot insert explicit value for identity column in table when INDENTITY_INSERT is set to Off code example
Example: Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SET IDENTITY_INSERT MyTable ON
-- INSERT INTO MyTable...
SET IDENTITY_INSERT MyTable OFF