How do I reset an increment identity's starting value in SQL Server
Just a word of warning with:
DBCC CHECKIDENT (MyTable, RESEED, 0)If you did not truncate the table, and the identity column is the PK, you will get an error when reaching pre-existing identites.
For example, you have identities (3,4,5) in the table already. You then reset the identity column to 1. After the identity 2 is inserted, the next insert will try to use the identity 3, which will fail.