Microsoft KB Archive/169376

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.