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)
