Custom Coloring Query Window in SSMS

Posted on : 12-08-2011 | By : Devi Prasad | In : SQL Server Basics, SQLServerPedia Syndication

Share:

0


Sql Server Management Studio Provides a feature to custom color SSMS for each registered server.
This feature will be really useful when the user needs to identify the kind of server he is actually connected to so that he can be careful while executing the queries.

In a generic situation a developer can select the following Custom colors:

  • Development Server – Green Color
  • UAT Server – Orange Color
  • Production Server – Red color

Following are the steps to set up custom color for a Server:

1) Open registered servers dialog in ssms.
  Click on view > Registered Servers
  Alternate way to open registered servers is by using the shortcut Ctrl+Alt+G

2) In Registered Servers window expand Database Engine then Right Click on Local Server Groups

3) Now select New Server Registration

4) In the New Server Registration window give the server name and authentication details

New Server Registration

New Server Registration

5) Click on Connection properties tab.

New Server Registration Connection Properties

New Server Registration Connection Properties

6) You can find Use Custom Color option where the necessary custom color can be selected for the registered server. Select a color and click on test and then on save.

Now the process of registering a server and giving it a custom color is complete.

In order to test the custom color expand Local Server Groups in registered servers.
You will find the newly registered server here.
Right Click on the server and click on New Query.

A new query will open and you will be able to see the custom color for this server at the bottom of the query window.

Custom Color in query window

Custom Color in query window

Points to note:
1) The first point is that the custom colors can be opted only for those servers that are registered in SSMS. Only registered servers in SSMS can have custom colors
2) Custom color will be shown only when the query is opened from registered servers.
Shortcut to open registered servers in ssms is ctrl+alt+g

(Visited 28 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: , , ,