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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply