• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 31
  • Last Modified:

SSMS change server in same file

I have a file open in SSMS  that has a different queries from a few different servers.  All servers are connected and open in the object explorer.   How can I switch back and forth between the servers without creating a new query?  Much like the USE STATEMENT to switch between db's in a server?



use data1
select * from companyfiles


use CompanyInfo
select * from AccountingData


use client
select * from SalesInfo
Charles Baldo
Charles Baldo
1 Solution
Pawan KumarDatabase ExpertCommented:
This is not possible. If they are linked servers the only u can use four part name queries otherwise not possible.you have to click on the server name and the open a new query and choose db and the write query
Charles BaldoSoftware DeveloperAuthor Commented:
Thanks Pawan

I have searched and found nothing, thought it was my limited knowledge.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now