How to work with Registered Servers in SQL Server Management Studio

Leave a Comment / SSMS / By /

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

Spread the love

Leave a Comment

Himanshu Patel SQL server database auditing
db tool - Copy

auxiliary.it.india@gmail.com

Skype @hapatel76

Facebook-f Twitter Linkedin Stack-overflow