Color coding SQL Server 2008 databases

Question

I often have multiple databases open in SQL Server 2008. Often they are prod, dev, and dr. It is annoying because each window says something generic like SQLQuery1.sql... (sa(200))*. So I have to hover over the tab and make sure I am in the correct window.

Is there a way to color code each window, or in some way to make it instantly knowable which database or server I am in?

Jonathan

Answer 1

I'm not sure about changing the colors, but I got tired of the small tab truncating the window name. As a result I run them as windows, so the entire DB name shows in the window's frame.

I have 2005 (shouldn't be that different than 2008) and this is where I made the change:

tools - options:
    environment
        general
            MDI Environment

Answer 2

Yes, you can color-code connections in SQL 2008, by modified the properties of the registered server. There is a "Use Custom Color" option on the Connection Properties tab.

See this cool tutorial video by the Midnight DBA