Bug: Cross-database queries change "current" DB

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Bug: Cross-database queries change "current" DB

Postby paschott » Fri Aug 27, 2010 12:40 am

Looks like when we do cross-database queries, SQL Prompt 5 loses some of the information or switches its DB context. When trying something like:

select *
from dbo.TableA as a
JOIN NotCurrentDB.dbo.TableB as b
ON a.ID = b.TableAID

SQL Prompt acts as if I'm currently using NotCurrentDB instead of whatever my current database actually is.

Running on SQL 2008 R2 SSMS - no updates / service packs
Server == SQL 2005 SP3
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests