• 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?

example

--TEST-SERVER1

use data1
select * from companyfiles

-- DEV- SERVER1

use CompanyInfo
select * from AccountingData

--PROD-SERVER1

use client
select * from SalesInfo
0
Charles Baldo
Asked:
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
0
 
Charles BaldoSoftware DeveloperAuthor Commented:
Thanks Pawan

I have searched and found nothing, thought it was my limited knowledge.
0
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