troubleshooting Question

Transact-SQL - connect to a different SQL server.

Avatar of whorsfall
whorsfallFlag for Australia asked on
Databases
5 Comments1 Solution2345 ViewsLast Modified:
Hi,

I am wondering how can the following be done from Transact-SQL (SQL 2000). From the query window connect to a different SQL server using T-SQL code.
Like the "USE" command but switching servers instead of just databases. (I want to have a big SQL script that can connect to multiple SQL servers) without
having to do lots of mouse clicking etc :)

E.g. (I know the syntax is wrong).

USE <SQL Server>
USE <Database>


Thanks,

Ward.
ASKER CERTIFIED SOLUTION
hollween

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros