SSMS color code your environments

SQL Server SP_what

Ever executed a script on the wrong environment? Neither do I… but for those who do need a visual queue as to which server you are on, I’ve included some helpful steps below:

SSMS color code in action

To configure SSMS color codes; Within SQL Server Management Studio, Open the Server Registration Properties dialog. Click on the “Connection Properties” tab, select “Use custom color” and select the desired color. Save your changes, open a new Query window and voilà.

Note: Keep in mind that this will only work for registered servers

Edit server registration properties

sql server query window color code

Post Navigation