USE tempdb
go
CREATE TABLE dbo.Test1 (
		pkID INT IDENTITY (1, 1) NOT NULL,
		Name VARCHAR (20) NOT NULL ) ;
		
SET IDENTITY_INSERT dbo.Test1 ON
INSERT INTO dbo.Test1(pkID, Name) VALUES (-1, 'UNKNOWN')
SET IDENTITY_INSERT dbo.Test1 OFF;

DBCC CHECKIDENT (Test1, reseed, 0);
INSERT INTO dbo.Test1 (Name) VALUES ('Expecting 1');

SELECT * FROM dbo.Test1;
DROP TABLE dbo.Test1;