SQL Server 2008: Change Color of Status Bar

When working in big organisation you will run across that you will need to work in different environments (Development / User Acceptance Testing / Production) this leaves you with a problem that sometimes you will not know from one easy look which environment you are working on. This can be solved by the following:

Once you reach the database login click on the options >>

Then Click on the Connection Properties Tab, and then the check box Use custom color, then click the Select... button

Then on the color pallet screen select the desired color to use:

The Recommended Colors are:

Production : RED

UAT:           ORANGE

DEV:           GREEN

Click OK and then CONNECT.

Now when you run a New Query on SQL Server the display will be as follows:

Now you can from one easy look see on what environment you run your queries.