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.
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment