Can you customize SSMS to have different background colors on the query window based on the connection.

I want to have different background colors for my query windows in SQL 2008 based on the server and/or database I'm connected to in that window.  
For instance I have 3 environments: Prod, DEV and test.  
If I'm connected to prod, I'd like the background to be white, when in dev I'd like the background to be light blue and when in test I'd like the background to be light green.  
Managing different connections in the same window can be confusing for some.  

If the above is not possible, any other suggestions for differentiating between multiple connections?
BobbyEarlAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
This is still impossible. Maybe if you ask MSFT they could integrate it to the next release... It does not seem to be impossible.

The only option (known to me) is to assign proper name to each newly opened query window (tab). The query name is obviously the only visible part and it is somehow helpful but not always. So if I need some recognition, my query tab names are starting with PROD and BETA. The DEV environment is the most often used DB and to change the query name is not obvious to me. I am trying to minimize the time of opening PROD and BETA tables. Sometimes I am opening them in separate SSMS instance.

Another possibility is to move SQL Editor toolbar more right to see the database name above the query.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BobbyEarlAuthor Commented:
Thanks for the reply.  I'll continue to use separate RDP sessions to distinguish between environments until I can find a better way.  
0
BobbyEarlAuthor Commented:
I found a solution!!!!  SSMSTOOLSPACK.COM.  
It will let you configure a colored bar that goes along the top, left or right of the query window depending on your connection.  It also has some other cool features.
0
pcelbaCommented:
Now I remember - I've seen this tool before but totally forgot about it... Thanks for the notification and sorry for my weak memory.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.