Colour coding of the status bar in SQL Server Management Studio - Oh dear
- by simonsabin
The new feature in SQL Server 2008 to have your query
window status bar colour coded to the server you are on is great. Its a nice way
to distinguish production from development servers. Unfortunately it was pointed
out to me by a client recently that it doesn't always work.
To me that sort of makes it pointless. Its a bit like having breaks that work
some of the time. Are you going to place Russian roulette every time you execute
the query.
Whats more the colour doesn't change if you change the connection. So you can
flip between dev and production servers but your status bar stays the colour you
set for the dev server.
It really annoys me to find features that sort of work. The reason I
initially gave up on SQLPrompt was that it didn't work 100% of the time and for
that time it didn't work I wasted so much time trying to get it to work I wasted
more time than if I didn't have it. (I will say that was 2-3 years ago).
If you would like to use this feature but aren't because of these features
please vote on these bugs.
https://connect.microsoft.com/SQLServer/feedback/details/504418/ssms-make-color-coding-of-query-windows-work-all-the-time
https://connect.microsoft.com/SQLServer/feedback/details/361832/update-status-bar-colour-when-changing-connections