1

When you add a Server Instance to Central Management Servers or even your local instance of SSMS, if you click on the connection properties tab you can select the default database you'd like to connect to as well as network protocols connection and execution time-outs and even a custom color for the taskbar when you open a query to using the connection you're defining.

This allows you to shutdown SSMS on your machine and come back days/weeks/years later and connect to a previously connected server and have these connection properties already populated.

This information has to be stored in table in one of the four default databases, but I have been unable to locate any of this information. I'm particularly interested in the fields that define the custom color of the taskbar for a connection.

I'm working on re-organizing my company's CMS and would like to organize by tier/environment and color code each one differently.

So all

  • production servers would be red,

  • Beta/Stage would be Orange,

  • QA would be green,

  • Dev would be blue.

I have already crafted a query to insert each Server Instance from a table into CMS, but can't seem to figure out how to populate the default connection's color.

Any help is much appreciated.

3
1

The list of the servers are kept in the msdb database.

SELECT * FROM msdb.dbo.sysmanagement_shared_registered_servers

If you're wanting the connections and tabs to be the same, then you would need to go to Tools --> Import and Export Settings... and export the selected environment settings. The two that would work for what you're asking for is under Options --> Environment. The two options would be "General" and "Tabs and Windows". It will export to a file. Send that to whomever will need it, and they can import it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.