Identity Columns in MS SQL Server
When working with Identity Columns in MS SQL Server, and specially when testing your database and inserting some junk data for the sake of testing, you ask yourself, how would I reset my Identity Columns to their original values after I finish testing with the junk data?
dbcc checkident (Table1, reseed, 1)
Hope that helps.
Regards