Showing posts with label SQL 08. Show all posts
Showing posts with label SQL 08. Show all posts

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.