How to work with Registered Servers in SQL Server Management Studio

In SQL Server management studio their is powerful option to easily connect your server or execute query on that server

To open register server window Menu -> view -> register servers
Or Ctl + Alt + G

Registered server window in SQL Server Management studio SSMS
Registered server window in SSMS
Add new Server group in SQL Server management studio SSMS
Add new server group in SSMS
Add new server in SSMS with server name and credential, you can save server credential too.
Additional property like default database, custom color in register server connection
find different command option in reverse click of mouse

We can run same query on all server using this feature

Ref Link https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-2017

Please follow and like us:

Leave a Comment

Your email address will not be published. Required fields are marked *

error

Enjoy this blog? Please spread the word :)