FIX:Recovery May Not Reset IDENTITY Value After TRUNCATE TABLE

ID: Q147408

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# 13135 (6.00)

SYMPTOMS

The current value for a truncated table is not the seed value after a restart of SQL Server.

CAUSE

If recovery has to recover INSERTs done prior to a TRUNCATE TABLE, then the reset seed value is not recovered correctly. This would normally only happen after an unexpected shut down of SQL Server.

WORKAROUND

Perform a CHECKPOINT before the TRUNCATE TABLE to flush all outstanding IDENTITY information. Or, you can perform a single INSERT after the TRUNCATE TABLE and before a shutdown can occur.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 identity truncate


Keywords          : kbusage SSrvProg kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 24, 1999