Changing Bar Colour Based on SQL Instance Connection

I found something extremely useful whilst perusing the MSDN forums the other day – The fact that you can change the colour of the connection bar in SSMS based on the instance of SQL Server you’re connected to!

It’s extremely easy to implement, but helps differentiate which server you’re looking at when working with multiple servers in multiple tabs. This means you can have one colour for a local server, another for a development testing server, and another for a live environment.

To start using a colour, open up SSMS.

From the Connect to Server dialogue box, click “Options >>” to expand the window.

On the Connection tab, select the instance you’d like to configure.

Go to the Connection Properties tab, and tick “Use custom color” – this while make the “Select” button on the same line available. Click “Select”, and choose a colour you’d like to associate with this instance – note that you can change this as much as you like.

SSMS Custom Colour

SSMS Custom Colour

Now click “Connect” to connect to your chosen instance, and you should notice that the bar towards the bottom of the screen is colour you picked in the last step.

SSMS Bar Custom Colour

SSMS Bar Custom Colour

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)