Custom Connection Colors in SQL Server 2008 Management Studio

SQL Server 2008 Management Studio has a new, little known feature that lets you set custom colors for your saved connection properties for different SQL Server instances. This allows you to save a specific color for different types of servers; for example red for Production, green for Test, etc. You have to set the color individually for each saved connection, but you only have to do it once.

After you have done this, it will be much more obvious whether you are connected to a Production server in a particular query window. This might help prevent you from making a very costly, resume updating mistake, such as TRUNCATING your Customers table in Production…

Here is how you set this property for each connection:

Open the “Connect to Server” dialog

 

Click on the “Options” button

 

Click on the Connection Properties tab

 

 

Check the “Use custom color” checkbox and click on the “Select…” button

Choose a fairly dark background color (so the text will be visible), and click on the “OK” button.

 

 

Notice the green background color for the connection information at the bottom.

 

Technorati Tags:

This entry was posted in SQL Server 2008. Bookmark the permalink.

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