DBCC CHECKIDENT is quirky. If you run it to reset an identity column such as
DBCC CHECKIDENT (jobs, RESEED, 30)
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2003/10/21/337/
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2003/10/21/337/