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
Tags: Databases & SQL
22b0d2e2-9798-4076-a301-87aa35135418|0|.0