July 31, 2024 at 12:00 am
Comments posted to this topic are about the item Using Registered Servers in SSMS
July 31, 2024 at 5:42 am
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.
July 31, 2024 at 6:56 am
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.
August 1, 2024 at 3:30 pm
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
August 1, 2024 at 4:49 pm
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.
August 2, 2024 at 2:54 pm
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?
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
August 2, 2024 at 4:09 pm
Not in query analyzer. Might have been in Enterprise Manager, but I can't remember.
August 2, 2024 at 8:08 pm
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply