--Check what currently is
DBCC CHECKIDENT (’tablename’, NORESEED)
--Reset
DBCC CHECKIDENT (’tablename’, RESEED, 1)
Showing posts with label SQL: Reset column identity. Show all posts
Showing posts with label SQL: Reset column identity. Show all posts
Friday, 30 October 2009
Subscribe to:
Posts (Atom)