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?
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