SSMS change connection to multiple servers
In SSMS, I can use the registered servers pane to open a new query window connected to multiple servers. Make it so that I can then right-click in that window, choose "connection / change connection," and then change my connection to a new group of servers, or at least choose multiple single servers. As it is now, "change connection" only lets you point at a single server.
Thank you for the suggestion. We’re not planning any changes in this area at the moment.
Mark Freeman commented
What @JediSQL said. Even if I had to right-click and select New Query instead of drag and drop, that would be a great enhancement. But drag and drop to an existing tab would save me from having to open a new tab and then copy/paste from the existing one to the new one to execute that SQL against a new group of servers.
Simon Byles commented
This would be very useful.
I wish I could multiple select a set of servers in the registered servers pane and drag and drop them on a query window, and that would change the windows connection(s) to that set of servers. Then I would not have to predefine every multiple server set I might need to use.