Generally, to reset an identity column to value n on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,n)
So, to reset an identity column to value 17 on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,17)
December 27, 2007
Subscribe to:
Posts (Atom)
Here you'll find solutions to random problems you may encounter whilst programming or using certain software tools (SSIS, Reporting Services, SharePoint, Business Objects, etc...)