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