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
 SQL Server Administration (2000)
 connecting to remote database through querry analy

Author  Topic 

steel
Posting Yak Master

107 Posts

Posted - 2008-05-08 : 02:23:59
hi all,


I want to connect to a remote database through the q. analyzer of my machine and want to run a query on the remote machine.

thanks in advance.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-08 : 03:18:06
Either connect via IP address or set up a linked server.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-08 : 22:12:04
Linked server is the way to go.
Go to Top of Page
   

- Advertisement -