William Vach (10/15/2010)
Thanks for the information. I was not aware that you could also set the query window color through the connection dialogue box. I did discover a quirk when using that method. It looks like the color is associated with the instance entry in the drop down. If you are connected to an instance and then change to another instance that you manually key in, the status bar will retain the color of the instance that you were originally connected to and also change the color of the manually keyed in instance when you subsequently select it from the drop down.This QOD sure brought out a lot of discussion about a little known but useful feathre of SSMS.
Yes, it is associated with the instance. It works this way for both connections set up in your registered servers, and for when changing connections or selecting "Connect" in the object explorer.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes