FIX: Timestamp Col of Temp Table Set to 0 When Inserting Row |
Q138848
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.
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.
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
|
Last Reviewed: March 11, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |