Using Registered Servers in SSMS

Question

Using Registered Servers in SSMS

Frank Dolan

Say Hey Kid

Points: 693
More actions
July 31, 2024 at 12:00 am

#4439247

Comments posted to this topic are about the item Using Registered Servers in SSMS

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

P Jones SSChampion Points: 12361 More actions · Answer 1

Good to see a post highlighting the basics for those newer to SQL Server.

Server registration was a life saver back in 2004-2015 when I was DBA for many SQL Servers scattered around the country and I still use the registered server list daily to access with a click.

Dani Sardà SSC Veteran Points: 264 More actions · Answer 2

Good article. Very clearly explained.

Let me add this. A feature I like in the Registered Servers is the ability to assign a custom color in the Connection Properties of the Registered Server, so I can visually identify if open queries ar connected to a Production, Test or Development server.

Later on I discovered SQL-Prompt utility for assigning them based on custom rules.

This reply was modified 3 months, 2 weeks ago by Dani Sardà.

Steve Jones - SSC Editor SSC Guru Points: 736105 More actions · Answer 3

I haven't ever used registered servers much, but I can see how I might use this in a larger environment, especially the grouping. In today's cloud world, this could be very useful

frederico_fonseca SSCoach Points: 16152 More actions · Answer 4

use it all the time - and our DBA team has a central server with CMS setup so it is available to all DBA's (and some snr developers/architects) as well.

in my opinion its a must have for anyone that works with more than a dozen of servers - small numbers can be done with local CMS (per user) but otherwise a central CMS server is really a great thing to have.

Phil Parkin SSC Guru Points: 246948 More actions · Answer 5

I can't remember a time when I didn't use this, along with the colouring options provided by SQL Prompt.

Did it also exist in the olden days of Query Analyser?

This reply was modified 3 months, 1 week ago by Phil Parkin.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Steve Jones - SSC Editor SSC Guru Points: 736105 More actions · Answer 6

Not in query analyzer. Might have been in Enterprise Manager, but I can't remember.

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 7

Another feature that I use is to create a folder of specific servers - then open a new query from that folder. It creates a query window connected to all of the instances listed in that folder.

I can easily check all of my systems by opening a query window and running a single query across all servers.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs