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.