Home Dashboard Directory Help

set custom backcolor of server name in SSMS by purpleintrepid3



Sign in
to vote
Type: Suggestion
ID: 774035
Opened: 12/11/2012 8:58:12 AM
Access Restriction: Public



I have had problems confusing which server I'm working on, dev or prod. I'd like to be able to set the backcolor of the server node in SSMS, so I can say, for example, dev is green, prod is red. It would also be great if the query window backcolor matched that of the server.

Thanks for your consideration,

Sign in to post a comment.
Posted by Microsoft on 2/7/2013 at 6:06 PM
Hi!, thanks for writing in to Microsoft.

We took a look at this feature request recently and triaged it against several others and unfortunately, it did not meet the bar to be fixed and we are closing this issue as 'won't fix'.

As a workaround, you can use custom colors for status bars of your query editor windows to indicate which server you are connected to.

Sanjay Nagamangalam, SQL Server Manageability
Sign in to post a workaround.
Posted by SAinCA on 2/8/2013 at 2:21 PM
Correction re SSMS Tools:
1. SSMS2005 doesn't support coloring the tab/status but does have the "stripe".
2. 2008R2 lets you color the connections using the Options on the connection dialog, plus the stripe from SSMS Tools.

Apologies, it had bee a while since I was in SSMS2005.
Posted by SAinCA on 2/8/2013 at 10:47 AM
If you are BELOW SSMS2012, use the FREE ssms tools (www.ssmstoolspack.com). If at 2012, then there are paid options...

One feature is to color-code the script window by Server. Tab, status bar and an optional left or right stripe of the same color down the edge of the window - very helpful.

If you have Red Gate's SQL Prompt, the "experimental feature" to color the tabs in SSMS2012 freaks it out - crash, crash, crash, turn off!!! Wait until it is "relentlessly tested".