The Business Intelligence Blog

September 20, 2009

SSMS 2008 New Feature

Filed under: SQL Server Database — Shahfaisal @ 11:56 am

This feature will let us know which server(instance) we are on when working with SSMS. In SSMS 2005, in order to find out the server we are working on, we need to hover the cursor on the current tab. This is kind of a pain when we are working simultaneously on two or more separate instances. Every time we run a script, we need to make sure we are on the right server to prevent any accidental changes to the wrong box.


In SSMS 2208, we can very well distinguish one server form the other. In the registered servers, right click on the server and go to properties , then go to the “connection properties” tab and use the custom color to select the color you want(something like RED for Production server and GREEN for Test server).


Now, every time you connect to that server, down at the bottom you will see that color to let you identify the server you are on. Please be sure to connect from registered servers window.


This will work even with a SQL 2005/2000 instance. Meaning, you can use SSMS 2008 to connect to a 2005 or 2000 instance and enjoy  this feature.


1 Comment »

  1. Nice one.

    Comment by sally — September 20, 2009 @ 10:10 pm

RSS feed for comments on this post. TrackBack URI

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 )

Google+ photo

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

Twitter picture

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

Facebook photo

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


Connecting to %s

Blog at

%d bloggers like this: