Editing Colour coding connections

'''Objective:''' To provide instructions on how to colour code connects to SQL Server via SSMS.

'''Reason for lesson:''' Colour coding connects will give the user a visual indicator of the current connection. This will help in indicting connections to dev, test and production servers.

| Registered Servers | Database Engine | Local Server Groups | Select Database |

'''Steps to colour coordinating SQL Server connections:'''

1. Open Registered Servers/Database Engine/Local Server Groups. 
2. Right mouse click on a database and from the popup menu select Properties.
3. From the Edit Server Registration Properties window click on the checkbox “Use custom colour:”. Press the “Select” button once it becomes available. 
4. From the colour selection window select the appropriate colour for the connection. Suggested colours: connection to development server = green. Connection to test server = yellow. Connection to production server = red. Press the OK 
   button.
5. After selecting the colour for the connection the Edit Server Registration Properties window will show the selected colour. Press the Save button.
6. From the Registered Servers list double click the server with the recently assigned colour. A connection to that server is made and the Object Explorer is presented.
7. From Object Explorer list of databases, right mouse click over a database and select New Query from the popup menu.
8. Once the New Query window opens you will see the colour of the information bar at the bottom of the window is now the colour previously selected.