01 Feb 2013 How to reset Primary Key value of MS SQL Server table? Posted by nikola, With 0 Comments, Category: Databases, Tags: sqlserver Just run following query: DBCC CHECKIDENT('YourTableName', RESEED, 0) This one is often used after truncating table - under usual curcumst ... Read more