{"id":67,"date":"2011-08-12T08:29:48","date_gmt":"2011-08-12T08:29:48","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/08\/12\/custom-coloring-query-window-in-ssms\/"},"modified":"2011-08-12T08:29:48","modified_gmt":"2011-08-12T08:29:48","slug":"custom-coloring-query-window-in-ssms","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/08\/12\/custom-coloring-query-window-in-ssms\/","title":{"rendered":"Custom Coloring Query Window in SSMS"},"content":{"rendered":"<p>Sql Server Management Studio Provides a feature to custom color SSMS for each registered server.<br \/>\nThis 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.<\/p>\n<p>In a generic situation a developer can select the following Custom colors:<\/p>\n<ul>\n<li>\nDevelopment Server &#8211; Green Color<\/li>\n<li>\nUAT Server &#8211; Orange Color<\/li>\n<li>\nProduction Server &#8211; Red color<\/li>\n<\/ul>\n<p>Following are the steps to set up custom color for a Server:<\/p>\n<p>1) Open registered servers dialog in ssms.<br \/>\n&nbsp;&nbsp;Click on view &gt; Registered Servers<br \/>\n&nbsp;&nbsp;Alternate way to open registered servers is by using the shortcut <strong>Ctrl+Alt+G<\/strong><\/p>\n<p>2) In Registered Servers window expand <strong>Database Engine<\/strong> then Right Click on <strong>Local Server Groups<\/strong><\/p>\n<p>3) Now select <strong>New Server Registration<\/strong><\/p>\n<p>4) In the New Server Registration window give the server name and authentication details<\/p>\n<figure id=\"attachment_633\" aria-describedby=\"caption-attachment-633\" style=\"width: 241px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2011\/08\/New-Server-Registration1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/08\/New-Server-Registration1.jpg\" alt=\"New Server Registration\" title=\"New Server Registration\" width=\"241\" height=\"300\" class=\"size-medium wp-image-633\"><\/a><figcaption id=\"caption-attachment-633\" class=\"wp-caption-text\">New Server Registration<\/figcaption><\/figure>\n<p>5) Click on Connection properties tab.<\/p>\n<figure id=\"attachment_624\" aria-describedby=\"caption-attachment-624\" style=\"width: 239px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2011\/08\/New-Server-Registration-Connection-Properties.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/08\/New-Server-Registration-Connection-Properties.png\" alt=\"New Server Registration Connection Properties\" title=\"New Server Registration Connection Properties\" width=\"239\" height=\"300\" class=\"size-medium wp-image-624\"><\/a><figcaption id=\"caption-attachment-624\" class=\"wp-caption-text\">New Server Registration Connection Properties<\/figcaption><\/figure>\n<p>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.<\/p>\n<p>Now the process of registering a server and giving it a custom color is complete.<\/p>\n<p>In order to test the custom color expand <strong>Local Server Groups<\/strong> in registered servers.<br \/>\nYou will find the newly registered server here.<br \/>\nRight Click on the server and click on New Query.<\/p>\n<p>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.<\/p>\n<figure id=\"attachment_635\" aria-describedby=\"caption-attachment-635\" style=\"width: 291px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2011\/08\/Custom-Color-in-query-window.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/08\/Custom-Color-in-query-window.png\" alt=\"Custom Color in query window\" title=\"Custom Color in query window\" width=\"291\" height=\"44\" class=\"size-full wp-image-635\"><\/a><figcaption id=\"caption-attachment-635\" class=\"wp-caption-text\">Custom Color in query window<\/figcaption><\/figure>\n<p><strong>Points to note:<\/strong><br \/>\n1) 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<br \/>\n2) Custom color will be shown only when the query is opened from registered servers.<br \/>\nShortcut to open registered servers in ssms is <strong>ctrl+alt+g<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,3],"tags":[182,183,184,185],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}