Continuing the two previous posts on employing custom color in SSMS using the built-in feature or SSMS Tools Pack to reduce error in connecting to a wrong environment, if you have access to Redgate SQL Prompt, this might be the easiest and best option to use. It’s so easy to configure as demonstrated that many developers overlook this feature.
Environment (Hex values)
Set Custom Color with SQL Prompt
In the SSMS top menu, click on SQL Prompt and select Options.
On the left pane of SQL Prompt – Options window, under the Tabs, click on Color and you will see another pop-up window with the default colors for typical enterprise environments.
Using the color value above, we can set up our own colors.
That’s all the steps needed to setup custom color coding, and here’s what they look like in SQL Server Management Studio v18.1: