Microsoft KB Archive/169376

From BetaArchive Wiki
Knowledge Base


BUG: Stored Procedure Execution Fails with Msg 202

Article ID: 169376

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q169376

BUG #: 16945 (WINDOWS: 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: kbbug kbusage KB169376