SQL Server Statement

Q: Reset the auto-increment identity value.

A: "DBCC CHECKIDENT (table_name, RESEED, 0)"

Ref : http://technet.microsoft.com/en-us/library/ms176057.aspx