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.
You can certainly use the default but for the sake of consistency, we’ll setup the same environment similar to what we did with SSMS and SSMS Tools Pack.
Environment (Hex values)
DEV (#66852E)
STAGING (#808000)
QA (#FF8000)
PROD (#BE0000)
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:
Further Reading
How to Use Custom Color in SSMS
Using Connection Coloring in SSMS Tools Pack
Format SQL Using Redgate SQL Prompt
Download
SQL Prompt (FREE Trial)
