Solved

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

Posted on 2009-07-09
4
443 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 41

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 41

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 70
Server running out of memory - Something is consuming all the available memory 17 61
hyperlink data type in SQL 3 28
SQL Insert parts by customer 12 34
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

777 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