BUG: Opening Cursor on a Local Temp Table May Fail with Msg 16Last reviewed: April 10, 1997Article ID: Q161434 |
The information in this article applies to:
SYMPTOMSWhen you declare a cursor with an order by clause on a local temporary table, you may receive the following error message when you open the cursor:
Msg 16919, Level 16, State 1 Cannot open cursor--referenced object (NAME NOT RECOVERABLE) dropped already WORKAROUNDTo work around this problem, run the DECLARE and OPEN cursor statements in the same batch.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
|
Additional query words:
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |