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