Reset Identity column in SQL Server

We are going to see How to Reset Identity column in SQL Server

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

Syntax:

DBCC CHECKIDENT('Customer', RESEED, 0)

Visit here for more information:

http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

Thanks :)