Managing List of MSSQL Servers via SSMS in 5 Simple Steps

It is really a hassle to manage a list of Microsoft SQL Servers (MSSQL Server) via Microsoft SQL Server Management Studio (SSMS) especially when it requires you to manage multiple database connections.

I admit that one of the grave mistake that I did was to use the Server name dropdown list in the Connect to Server dialog box to select the database that I wish to connect as highlighted below:

Drop down list in SSMS
If you use this dropdown list, I wish you best of luck!

Read more