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