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.
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.
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.
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.
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
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