Tuesday, April 28, 2009

SQL 2008 Resetting auto increment indexes

Found this useful for resetting the auto-increment indexes on a SQL 08 database.

DBCC CHECKIDENT ("database.dbo.tablename", RESEED, 0);

No column name needed.

No comments:

Post a Comment