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
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