BUG: Problems Opening Cursor on Global Temporary Table

ID: Q158289

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG #: 15653 (6.00)

SYMPTOMS

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.

WORKAROUND

To work around this problem, use a permanent table rather than a global temporary table.

STATUS

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 SSrvStProc kbbug6.00 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 2, 1999