Microsoft KB Archive/148224

= BUG: Cross-database table creation/drop in stored procedure =

Article ID: 148224

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q148224



BUG# NT: 13656 (6.00)

BUG# 225688 (shiloh_bug)



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.



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



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Additional query words: sql6

Keywords: kbbug kbusage KB148224

-

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

© Microsoft Corporation. All rights reserved.