Posted by Tom Moreau on 01/24/06 18:45

There's often a performance difference.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"MC" <marko_culo#@#yahoo#.#com#> wrote in message
news:dr5eu2$s5q$1@magcargo.vodatel.hr...
Agreed, but why not provide a more complete info since theres a little
difference? He may need to pull data from two servers tomorrow...


MC


"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:LBqBf.4368$ft2.109590@news20.bellglobal.com...
> The OP said the two DB's were on the same server. Therefore, 3-part
> naming
> is sufficient.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
>
> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
> news:dr5cc8$bue$1@magcargo.vodatel.hr...
> Try 'four part names' :).
> server.database.owner.table
>
>
> MC
>
>
> "Captain Nemo" <nemo@nospam.com> wrote in message
> news:6oqBf.8267$wl.3901@text.news.blueyonder.co.uk...
>> Hi
>>
>> I'm working on an ASP project where the clients want to be able to
>> effectively perform SELECT queries joining tables from two different
>> databases (located on the same SQL-Server).
>>
>> Does this involve creating virtual tables that link to another database,
>> or
>> am I completely on the wrong track?
>>
>> Any hints as to where I might find more information (buzz-words, etc.)
>> would
>> be most appreciated.
>>
>> Thanks
>>
>>
>
>
>

[Back to original message]