Posted by MC on 01/24/06 16:20

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]