Susan Harkins
ssharkins at gmail.com
Tue Jul 1 11:20:54 CDT 2008
I'm running some tests on DBCC CHECKIDENT and only one surprise: DBCC CHECKIDENT (tablename, RESEED) deletes the table's records. Now, I wasn't expecting that, since the documentation says it corrects the seed value -- in truth, I wasn't sure what that meant, hence the testing. I'm going to do a little research, but if someone already has an explanation and doesn't mind sharing, please do. Susan H.