Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2009-07-09
4
Medium Priority
?
463 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 44

Accepted Solution

by:
pcelba earned 2000 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 44

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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

588 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