Microsoft KB Archive/138848

{|
 * width="100%"|

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

 * }

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.

RESOLUTION
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 : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600