BUG: Stored Procedure Execution Fails with Msg 202

• Microsoft SQL Server version 6.5

SYMPTOMS

When you execute a stored procedure, it fails and returns the following error:

Msg 202, Level 11, State 2
Internal error -- Unable to open table at query execution time.

CAUSE

The stored procedure does all the following:

• Creates a permanent table using the CREATE TABLE statement



• Drops the permanent table



• Creates a temporary table



• Declares a cursor on the temporary table



• Drops the temporary table

WORKAROUND

To work around this problem, do any of the following and then drop and re-create the stored procedure:

• Use the SELECT INTO statement to create the permanent table



• Eliminate either of the DROP TABLE statements



• Wrap the DECLARE CURSOR within an EXEC()



• Create the stored procedure WITH RECOMPILE or always execute it with the WITH RECOMPILE option.

STATUS

Microsoft 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.

Keywords          : kbusage SSrvStProc kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 16, 1999