Using Registered Servers in SSMS

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

  • 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.

  • 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, 3 weeks ago by  Dani Sardà.
  • 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

  • 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.

  • 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, 2 weeks 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

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

     

  • 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