BUG: Problems Opening Cursor on Global Temporary Table |
Q158289
If a stored procedure creates a global temporary table, then running
another stored procedure that opens a cursor on this global temporary table
may cause either a thread-level access violation (AV), shut down server (if
its query plan has been pushed out of the procedure cache), or cause the
following error message:
Error : 706, Severity: 20, State: 1
Process 10 tried to remove PROC_HDR 0xbf4800 that it does not hold in Pss.
To work around this problem, use a permanent table rather than a global temporary table.
Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Additional query words: unhandled exception
Keywords : kbusage
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: April 4, 1999 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |