Reset identity seed in SQL Server

 DBCC CHECKIDENT ('TableName', RESEED, 1000); 

Comments