• To get this to always work, there are TWO places to set it:

    1. On a registered server, select the "Connection Properties" tab, and set the color.

    2. On the Object Explorer, if you click on connect and select a server, you will need to set it there on the "Connection Properties" tab also - it doesn't pick up the color from an associated registered server of the same name.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2