[dba-SQLServer] Fw: RESEED deletes records

Susan Harkins ssharkins at gmail.com
Tue Jul 1 11:34:35 CDT 2008


I forgot to mention that I'm using SQL Server 2005 Express -- not sure why 
that would matter, but it might.

Susan H.


> 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