[dba-SQLServer] RESEED deletes records

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. 




More information about the dba-SQLServer mailing list