Table of Contents

How To Reset Identity Column Value in SQL Server

Check Identity Value

DBCC CHECKIDENT (tablename, NORESEED)

Set Identity Value

DBCC CHECKIDENT (tablename, RESEED, identvalue)

This means that the number you input in place of 'identvalue' should be the CURRENT last index. The next value will be identvalue + 1. If you enter 999 then the next record inserted will have a value of 1000.

To reset a table: 

DBCC CHECKIDENT (tablename, RESEED, 0)

Sources

http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/