Set custom colors to differentiate between environments in SSMS

Introduction

Generally we have to shift between different environments within SQL Server Management Studio, as Dev Environment, Staging, Production, resulting in the creation of multiple query tabs. With each query tab connected to different environments. This leads to unmanageable sometimes and difficult to keep track of each environment. To resolve this confusion, SSMS provides us with an ability to set different colors for connection to separate environments. The color is displayed in the SSMS status bar, at the bottom of the window.

Set Custom Colors

  • Connect to a SQL Server instance and click on the Options button.
Fig.1 Connect to SQL Instance
  • Then click on the ‘Connection Properties’ tab and you can choose a custom color for your environment
Fig.2 Choose the color for your environment

Once you select a color for an environment, every time you login to that SQL Server instance, it will display the same color in the SSMS status bar. It’s always nice to have a visual indication of the environment you are logged in.

For my Development Environment I have set Green Color and when I open the query window, the status bar’s color will be in green color.

Fig.3 Example Environment with Status Bar Color

Conclusion

In this article, we have discussed about setting color to our SQL Instance Environment. I hope this tips was very useful. Lets discuss some other tips in upcoming articles. Please share your feedback in the comment section.

Consider reading other SQL articles of Mine

One thought on “Set custom colors to differentiate between environments in SSMS

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: