BUG: Cross-Database Table Creation/Drop in Stored Procedure

• Microsoft SQL Server, version 6.0

SYMPTOMS

After the database owner (dbo) of a database creates a stored procedure that creates a table in another database, inserts data into the table, selects from the table, and then drops it, the dbo then grants execute permission on this procedure to a user who is a user in both databases. When the user executes the procedure, it executes fine the first time, but on the second time and each time thereafter, the user gets the following error messages:

   Msg 2714, Level 16, State 1
   There is already an object named 'tblname' in the database.
   Msg 267, Level 16, State 1
   Object '' cannot be found.

WORKAROUND

Use the WITH RECOMPILE option to either create or execute the procedure.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.