SQL Server - How to reset Table Identity

DBCC CHECKIDENT can reset the identity value of the table. For example, YourTable has 10 rows with 10 as the last identity. If we want the next record to have the identity of 25, we need to run the following TSQL script in Query Analyzer.

DBCC CHECKIDENT (yourtable, reseed, 24)

If yourtable has to start with an identity of 1, the table should be reseeded with an identity of 0. If the identity seed is set below the values that are currently in the table, it will violate the uniqueness constraint and will generate error.