Resetting Primary Key counter in SQL Server

To reseed/reset the IDENTITY column of an SQL Server table, run the following in Query Analyzer or SQL Server Management Studio:

DBCC CHECKIDENT (Table_Name, RESEED, 1)

Peace!