Microsoft KB Archive/67326

PRSQL9106020: Procedure with SELECT INTO Cannot Be Restored ID Number: Q67326

1.10 OS/2 buglist1.10

Summary:

Problem ID: PRSQL9106020

SYMPTOMS After dropping and re-creating a temporary table that is used in a SELECT INTO statement in a stored procedure, or restoring a database with this same stored procedure, the stored procedure becomes invalidated. When the affected procedure is run, the following error message is displayed:

Invalid Object Name '' (Msg 208, Level 16, State 1) WORKAROUND Either of the following will correct this problem:


 * 1) Recompile the affected stored procedure.
 * 2) Create the temporary table using the “CREATE” statement, then enter all of the necessary values by executing an INSERT with a SELECT statement.

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.1. We are researching this problem and will post new information here as it becomes available.