SET IDENTITY_INSERT Table1 ON code example

Example: set identity_insert off

SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }