Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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.

like image 297
Feckmore Avatar asked Apr 14 '10 15:04

Feckmore


People also ask

How do I change the appearance of SQL?

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.

How do I change the theme in SQL Server Management Studio?

Reopen SSMS and navigate to the 'Color theme' dropdown as we did earlier. Now, we will see a fourth option for Dark Mode. Unfortunately, it only changes the Ribbon and the Query Window. The Object Explorer and Results Grid aren't changed.

How can I tell which database SQL Server is using?

Use SQL Server Management StudioIn Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. To see a list of all databases on the instance, expand Databases.


1 Answers

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

like image 95
KM. Avatar answered Oct 03 '22 07:10

KM.