Menu
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
375
Click Options on the Tools menu. Click Environment, and then click Fonts and Colors. In the Show settings for list, select Text Editor. Change the font, size, display item, foreground and background colors.
SQL Server 2008 and SQL Server 2008 R2 reached their end of support on July 9, 2019, while Windows Server 2008 and Windows Server 2008 R2 reached their deadline together with Windows 7 on January 14, 2020.
Editing environments and colors To change the color of an environment: In the SQL Prompt options, under Tabs > Color, click Edit environments. Click the color you want to change and choose a new color: Press Enter.
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
99
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
