THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Query window custom colouring now works properly [SSMS]

SQL Server 2008 introduced a new feature that had the potential to be very useful, the ability to color colour-code a query window in SSMS to represent the server that was being connected to. This was configured using the properties of a server in the Registered Servers pane:


Unfortunately this feature was made less than useful, dangerous even, by its behaviour. Changing the connection of a query window did not affect the colour thus raising the prospect of a user issuing queries against what they believe is a development server which in actuality is a production server. I haven’t met anyone since that hasn’t denounced this “feature” of SSMS.

Good news though. According to these Connect submissions:

this issue was fixed in SQL Server 2008 R2 Service Pack 1 and the fix will also appear in SQL Server Denali RTM (its not in any of the currently available CTPs). From Program Manager Sanjay Nagamangalam:

This bug and a related connect bug have been fixed in SSMS in SQL Server 2008 R2 SP1. Unfortunately, the fix did not make it in time for SSMS in Denali CTP3 and will be available in a subsequent release.

Good news indeed!


Published Thursday, August 11, 2011 9:28 PM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Peter Schott said:

About time this started working, but I'm glad that Mladen was able to get this working in the SSMS Tools Pack. That was one of the best features, apart from the Query History function. :)

August 11, 2011 3:52 PM

mjswart said:

Definitely good news indeed! (as the author of the _other_ connect item) :-)

August 11, 2011 4:19 PM

Dylan said:

Fantastic, now let's get the color coding a persisted setting in the CMS for registered servers!

August 11, 2011 4:56 PM

Jez said:

Was also going to mention SSMS Tools Pack.  imo best feature is SQL snippets ;-)

August 12, 2011 10:45 AM

juerg said:

I am on SqlServer 2012 Version 11.0.3000.0 and it still does not update the bar when changing connection.

It is therefore rather better to forget about this feature as it might give you the important wrong indication when executing stuff

February 13, 2014 1:55 AM

Leave a Comment


This Blog


Privacy Statement