Microsoft KB Archive/158289

{|
 * width="100%"|

BUG: Problems Opening Cursor on Global Temporary Table

 * }

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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600