BUG: Inconsistent Behavior with Global Temporary Tables |
Q148219
Global temporary tables exhibit inconsistent IF EXISTS behavior from
multiple connections. The conditional check for table (with IF EXISTS) may
return FALSE even if the global temp table exists. Create table statements
executed after this will return the following error message:
Msg 2714, Level 16, State 1
There is already an object named '##tablename' in the database.
Microsoft has confirmed this to be a problem in SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Additional query words: sql6
Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 28, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |