Here is something else fer ya. If you are linking a 64-bit version of SQL to a 32-bit, you will need to run a script on the 32-bit server that updates the system stored procedures.
http://support.microsoft.com/?id=906954 mike -----Original Message----- From: C. Hatton Humphrey [mailto:[email protected]] Sent: Friday, January 16, 2009 8:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
