>My application has 3 connections string:
>-Production
>-QA
>-Dev
>
>Each one of these environment has 4 databases. I very often have to join tables from different databases in a single query.
>
>select *
>from database1.dbo.table1 as t1
>inner join database2.dbo.table2 as t2
>on t2.xyz = t1.xyz
>
>
>Because it is a JOINed query, I cannot rely on the connection string to resolve both tables.
In that case, I understand.