i think you can specify the connection string to the remote server in the text of your query. Check sql books online for
OPENDATASOURCE and OPENROWSET -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] Behalf Of Mike Andrews Sent: Monday, July 02, 2007 2:34 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: [ADVANCED-DOTNET] Cross-Server Queries Guys, Perhaps I'm being crazy here, but is it possible to execute a cross-sql server query without having to set up a linked server in sql server? My problem is that I want to execute a sql statement against two different databases located on two different servers but I don't really want a linked server (or I'd rather not if at all possible). Any suggestions? Thanks, Mike =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
