Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to demonstrate the usage of IDENTITY_INSERT table property.

USE AdventureWorks
GO

SELECT * from Person.ContactType
GO

-- the following will fail
INSERT Person.ContactType(ContactTypeID, [Name])
VALUES (1000, 'Email Support')
GO

-- the following will succeed
SET IDENTITY_INSERT Person.ContactType ON

INSERT Person.ContactType(ContactTypeID, [Name])
VALUES (1000, 'Email Support')

SET IDENTITY_INSERT Person.ContactType OFF
GO

SELECT * from Person.ContactType
GO

DELETE Person.ContactType WHERE ContactTypeID=1000
GO

SELECT * from Person.ContactType
GO