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 :