SSMS pre register multiple server to avoid connecting it again and again

I recently learned about the registered servers feature in SQL Server Management studio. Below are benefits I felt more useful, and you can see details on the link above.
·         Can register multiple servers at once then no need to use connect to server window all the time.
·         Can group the servers, it helps easily organize these servers
·         You can double click in registered server window to open it in object explorer window.
·         You can run a query to multiple servers in one step (Risky, so not recommended but in case it’s the need)

Below is screen shot of my SSMS, I have created three groups DEV, TST, PROD and can connect to these server just by double clicking any of the servers . Even if you restart SSMS these registered servers are preserved.  There is a feature of import and export too and it can be useful if we want to give list of all the servers  to a new person in team.


Comments

Popular posts from this blog

Search column names in database

Typing Speed Test