Bug: Cross-database queries change "current" DB

Provides intelligent code completion for SQL Server editors.

Bug: Cross-database queries change "current" DB

Postby paschott » Thu Aug 26, 2010 11:40 pm

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
Posts: 64
Joined: Wed May 10, 2006 3:10 pm
Location: DFW, TX

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests