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.

image001

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).

image002

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.

image003

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.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: