FIX: Timestamp Col of Temp Table Set to 0 When Inserting Row

ID: Q138848

The information in this article applies to:

Microsoft SQL Server, version 6.0

BUG# NT: 11220 (6.00)

SYMPTOMS

When you insert a row inside a stored procedure (SP) into a temporary table that contains a timestamp column in a situation where the temporary table was created outside the SP and was deleted after the creation of the SP, the timestamp column is set to 0 when the SP is called.

WORKAROUND

If the SP gets called once after its creation and before the original table is dropped, the timestamp is set to a correct value in all subsequent calls.

STATUS

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

Additional query words: timestamp insert

Keywords          : kbprg SSrvProg kbbug6.00 kbfix6.00.sp2 
Version           : 6.0
Platform          : NT WINDOWS

Last Reviewed: May 3, 1997