mssql reset table identity
the following script resets the table identity seeding to 99, the next record will have identity of 100
DBCC CHECKIDENT ("[table name]", RESEED, 99);
GO
Friday, February 26, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment