Solved

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

Posted on 2009-07-09
4
448 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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

820 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