This is one very interesting issue which I have started to follow recently. Just like any other organization my company has many servers. Some are production and some are development. It is very much necessary that query which are written for developer environment does not run for production environment accidentally.
In SQL Server 2008 there is special feature which can change the color of the task bar. This will alert developer to run query on server.
Let us see quick tutorial with images which explains how the color of the status bar in SQL Server management studio can be changed.
Another example of different color status bar.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
Good to see status bar colors changing.
Is it possible in SQL Server 2005?
Hi Sagar,
No it is not possible to change the bar colors in SQL Server 2005 but only in SQL Server 2008.
Regards,
Pinal
I like this; sometimes the simplest of features can prevent a major accident.
I believe it works for Central Management Servers group as well
so a Production group can be RED while Development group can be GREEN
It’ll be PINK if you try to run multi-server script
Sometimes I find it doesn’t store the colour settings all the time…. didn’t bother to figure out why
hello
I want to change the color in results when we select some data tha use case by this we got some filter data which i want to chage color .
how can we did in sql 2005
[...] the following trick to separate different connections, which I mentioned in my blog sometime back SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor. However, this trick does not help when a huge number of different connections are open. In such a [...]