I'm sure our dba has this done already. Thanks for pointing it out though/
-----Original Message----- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 24, 2007 5:08 AM To: CF-Talk Subject: RE: SQL Server, querying between two DBs > 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:267460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
