This is the SSMS version I'm using:
Microsoft SQL Server Management Studio 12.0.4100.1
In previous versions (2008R2) I was able to set a custom color for my production and UAT server and SSMS remembered my settings. In the newer version (above) my "Use custom color" setting doesn't remember for each server independently. The color is always the last one that I chose no matter which server I connect to.
Is there a fix for this or perhaps it has something to do with my local installation of SSMS?
Click Options on the Tools menu. Click Environment, and then click Fonts and Colors. In the Show settings for list, select Text Editor. Change the font, size, display item, foreground and background colors.
For example: Select * from Employee; If EmployeeID = 100 I want the name column to be displayed in green color. If EmployeeID = 200 I want the name column to be displayed in red color.
To repair Management Studio open Control Panel, go to Programs and Features, locate SQL Server Management Studio using the scroll bar and make a double click on it. Once the SSMS dialog appears on the screen please click on the "Repair" button.
Hmmm.... I have SSMS 12.0.4213.0 (SQL Server 2014 SP1), and from what I can see, it works just fine.
I have set up several servers in my Registered Servers
list in SSMS, and each has a separate custom color, and those colors are in fact applied.
Update (05-Oct-2017)
Those colors are only applied to the query window inside SSMS if you
Registered Servers
window inside SSMSObject Explorer
(to open that server in OE), or New Query
to open a new query window for that serverIf you just pick the Connect
button inside Object Explorer and type in your server name, then those colors apparently are not applied ... (not sure if it's a bug - or a feature)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With