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