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

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 : winnt:6.0
Platform : winnt
Issue type :