patternsqlModerate
Save Connections in SSMS?
Viewed 0 times
savessmsconnections
Problem
Can I save some sort of session or profile in SSMS (2008 r2) that will open up connections to a saved list of database servers when I open SSMS?
So for example I frequently will open up SSMS and then connect to SQL Servers NY-DB01, NY-DB02 etc... Can I have some sort of shortcut just to open all of these at once?
So for example I frequently will open up SSMS and then connect to SQL Servers NY-DB01, NY-DB02 etc... Can I have some sort of shortcut just to open all of these at once?
Solution
Using SSMS, register the servers you're interested in and group them in a folder. Then you can connect to them all at once like this:
Context
StackExchange Database Administrators Q#7707, answer score: 10
Revisions (0)
No revisions yet.