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!
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!