In SQL Server, the keywords to Google are "linked servers". Mike
-----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2008 3:15 PM To: CF-Talk Subject: RE: Query Muliple Databases Correction... I double checked with our DBAs and they said it can be done. As long as SQL Server can se your DB2 database, and you have the proper drivers to allow the two to speak, then yes...you can do this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
