Wednesday 30 March 2011
Reset SQL identity to a custom value (RESEED)
--Replace tblName and 0 with the number you wish to reset the default value to
DBCC CHECKIDENT('tblName', RESEED, 0)
Subscribe to:
Posts (Atom)
About Me
- Tim Powell
- Yorkshire, United Kingdom
- I like to think of myself as a software engineer that always tries to push myself forward. Fortunately I have a great friend base that have helped develop my research skills allowing me to post good practices or solutions which we have created.