sql alter table set identity off code example
Example 1: tsql reseed identity
USE AdventureWorks2012;
GO
DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);
GO
Example 2: set identity_insert off
SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }