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)
Comments
Post a Comment