Posted by Tom Moreau on 01/24/06 16:11

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]