Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Query Analyzer and Two Databases Help

Author  Topic 

shade73
Starting Member

4 Posts

Posted - 2005-11-10 : 21:29:50
How do you run a query off 2 different servers using code in sql query analyzer. Now I don't want to join tables & such.. I'm just trying to run one query on one server, and below it run another query on another server... in the same window

[999.999.999.99]SELECT * FROM blah
[255.255.255.25]SELECT * FROM blah_server_2

is there anyway to do this?? Sorry I'm only a beginner at SQL.

Thanks!

shade73
Starting Member

4 Posts

Posted - 2005-11-10 : 21:30:40
Sorry about that, I was in the wrong forum!!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-11 : 00:27:12
Refer this
http://sqlteam.com/forums/topic.asp?TOPIC_ID=57600

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -