Solved

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

Posted on 2009-07-09
4
452 Views
Last Modified: 2012-05-07
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?
0
Comment
Question by:BobbyEarl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 24815927
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
 

Author Closing Comment

by:BobbyEarl
ID: 31601636
Thanks for the reply.  I'll continue to use separate RDP sessions to distinguish between environments until I can find a better way.  
0
 

Author Comment

by:BobbyEarl
ID: 26469012
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
 
LVL 42

Expert Comment

by:pcelba
ID: 26469366
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question