SQLTeam.com | Weblogs | Forums

DBCC CHECKIDENT weirdness

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/