Randy's blog
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.
Home
Subscribe to:
Posts (Atom)