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:
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