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 e...