How do I reset an increment identity's starting value in SQL Server

I would like to have a nice template for doing this in development. How do I reset an increment identity's starting value in SQL Server?

Solution 1:

DBCC CHECKIDENT('TableName', RESEED, 0)

Solution 2:

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.

Solution 3:

To set the identity to 100:

DBCC CHECKIDENT (MyTable, RESEED, 100)