BUG: Stored Procedure Execution Fails with Msg 202 (169376)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbusage KB169376 |
|---|
|