Color Coding SSMS

Finally got around to color coding my SQL Server Management Studio (2008) on my desktop today, which is a great feature if you haven’t set it up already.  Essentially it changes the color at the bottom of your query window which is usually a light yellow.  Why bother?

Well for me I set my production boxes to red, acceptance boxes to yellow, and development boxes to green to remind my brain whether it is safe to make changes to the environment.  Once you have a few query windows open, you tend to forget to which environment that window belongs to.  This is not foolproof, but it is a handy reminder to be mindful of your environment.

Not sure how to set it up?

Well using the registered servers feature, add your server and select the properties.  Then choose the connection properties tab and select the ‘use custom color’ option and then press select to choose your color.  Easy and remember to restart SSMS for this to take effect. Enjoy.


About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on July 12, 2012, in Maintenance and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: