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!