> Our dba finally got out of his meeting. Turns out that not > only are they separate databases, but they're also on a > different server. > > So it's [server_name].databasename.dbo.tablename.
This will work fine but remember to set up "linked servers" in Enterprise Manager or the cross-server join will fail. It is also worth noting that this can be rather unpredictable in speed sometimes returning results lightning fast and sometimes crawling so it may be worth setting up replication to copy one of the databases across to the other server and perform your queries against that. -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
