June 7, 2012 at 7:56 am
Hello Everyone
I would like to set my SSMS environment to show a NULL value as a different color background within SSMS grid view. I have seen this and done this before, but I cannot seem to find this setting. I have changed most of the other settings and colors or objects and text, but I cannot locate this one.
Thanks in advance
Andrew SQLDBA
June 7, 2012 at 8:47 am
If you dig around a bit on google you will quickly find that this is the color of your windows tooltip. From the 2 minutes googling it seems that this feature didnt really work, there are connect items around the settings not actually working. As a result they removed this setting in 2008r2 and 2012.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 7, 2012 at 11:16 am
I did find that changing the Windows tooltip color, that is changes the background color of any NULL value in SSMS. A long way around, but I am using 2008R2 and this will change the color.
Andrew SQLDBA
June 7, 2012 at 12:00 pm
AndrewSQLDBA (6/7/2012)
I did find that changing the Windows tooltip color, that is changes the background color of any NULL value in SSMS. A long way around, but I am using 2008R2 and this will change the color.Andrew SQLDBA
Yeah it all seems rather stupid that it is using a windows setting for the background color of null. It also seems like it would be really simple to fix.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy