FIX:Recovery May Not Reset IDENTITY Value After TRUNCATE TABLEID: Q147408
|
The current value for a truncated table is not the seed value after a restart of SQL Server.
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.
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.
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