Reset SQL Identity Seed Using Identity Increment

Reset SQL Identity Seed Using Identity Increment Back To 1 within Identity Specification

To reset the Identity Seed in MS SQL do the following within Microsoft SQL Server Management Studio:

1) Right Click the database that contains your table identity to reset

2) Click New Query

3) Within the query window enter the following line

DBCC CHECKIDENT(TableToReseed,RESEED,0)

4) Right click the query window

5) Click Execute

That’s all there is to it. I normally use this after testing to reset the database for live production.