How can I change the look of SQL Server Management Studio based on which database I'm connected to?

sql-server user-interface database-connection ssms
Feckmore picture Feckmore · Apr 14, 2010 · Viewed 15.6k times · Source

I'd like to modify the appearance of the query window in SQL Server Management Studio based on which database I'm currently connected to. For example, using a yellow background for production databases. Is there a way to do this?

Is there also a way to change the default color of the query status bar at the bottom (when a server is not selected from the Registered Servers tab)? I'd like to also make a bright and distinct color for when I don't remember to use the Registered Servers.

Answer

KM. picture KM. · Apr 14, 2010

In SQL Server Management Studio 2008 you can color code your connection without any add-ins. In SSMS 2008, go To Registered Servers and then Right-Click a server then Connection Properties tab then Select "Use Custom Color"

you can try an add-in for SQL Server 2005: SSMS Tools Pack which has Window Connection Coloring

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
OR is not supported with CASE Statement in SQL Server

The OR operator in the WHEN clause of a CASE statement is not supported. How can I do this? CASE ebv.db_no WHEN 22978 OR 23218 OR 23219 THEN 'WECS 9500' ELSE 'WECS 9520' END as wecs_system

Read More