Hi Jay

You need to have a look at linked servers, this article has a heap of stuff
in it.

http://www.databasejournal.com/features/mssql/article.php/3085211

Im sure there is a simpler route by prefixing the table with the
db.owner.table or something like that, Neil Ravo Robertson was the chap I
saw doing it a while back I will give him a shout and ask what he was doing.

HTH

Jose Diaz


On 9/6/06, James Smith <[EMAIL PROTECTED]> wrote:
>
> I have heard tell that it is possible to perform cross-database and even
> cross-server joins in MSSQL but I can't find any good info on how it is
> done.  Can someone point me in the right direction, specifically for the
> cross server stuff?
>
> --
> Jay
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252183
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to