Color code SSMS status bar

I work with all kinds of SQL Server instances.  All of them are one of three possible types:

  • Development
  • Test
  • Production

Many of my scripts have a quick query at the top to get the server name (@@servername).  I use this to double check the server instance I’m on.  More specifically, I use this to make sure I’m NOT on a production server (when not deploying production changes).

Andy Menon, a co-worker and all around genius, showed me how to change the color of the status bar depending on what server SSMS is connected to.  He suggested changing the color based on the type of the server connection, such as:

  • Development – GREEN (who cares, hack away, you’ve got the green light)
  • Test – YELLOW (caution, you may end up jacking up someone’s code)
  • Production – RED (STOP… do you know you are on a prod server?)

By making a simple change in the connection box for all of your servers your status bars can look like this:

Development Server:


Test Server:


Production Server:


There’s no new science here, but if it can spare me just one time from unintentionally executing code on a production machine, it is well worth the time to set this up.  Plus, I always know where I am!  What a concept…

Here’s a quick guide on how to do it:

  • In SSMS open a new database connection in Object Explorer.
  • Click on “Options”:


  • Click on Connection Properties


  • 4. Click Use custom color.
  • 5. Pick your color.
  • 6. OK… Connect.

Here’s the official Microsoft link on how to do this in Object Explorer (and Central Management Server).

Stay curious, keep learning…


Leave a Reply

You must be logged in to post a comment.

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>

football better than baseball pay for masters essay on lincoln custom mba essay ghostwriters for hire au popular thesis statement writing websites for masters professional masters critical analysis essay topics top descriptive essay ghostwriters site ca esl case study ghostwriter website us cheap bibliography ghostwriters site for university popular critical analysis essay writer websites for college custom business plan writer website ca top school annotated bibliography help a case for torture popular business plan ghostwriters for hire us content ghostwriters website gb definition essay proofreading websites online scholarship ghostwriting service gb fall of the aztec empire popular college essay writers services for school type my custom phd essay on civil war professional research proposal proofreading websites for school esl phd homework topic cheap masters essay ghostwriters site gb top cover letter editing site au order psychology essay popular problem solving writer websites for phd esl best essay writer site for university esl essay writers services uk type my drama essay esl assignment ghostwriters service for phd top college thesis statement example help with my top definition essay on pokemon go write technology annotated bibliography pay to do top reflective essay on usa rhetorical analysis essay ghostwriting for hire us popular dissertation introduction proofreading for hire for mba esl biography ghostwriter for hire for school popular masters dissertation methodology esl blog ghostwriter website us best phd essay writing services ca benny city of god da vinci code sophie pay to write top critical analysis essay on lincoln order popular reflective essay on lincoln custom admission paper proofreading service usa professional descriptive essay ghostwriter website us divine command theory example popular descriptive essay ghostwriter site for university popular letter proofreading for hire us cheap custom essay writer for hire usa best critical essay ghostwriting services usa help writing physics critical thinking esl biography proofreading site ca custom movie review ghostwriter website us professional dissertation methodology editing website for masters popular article review ghostwriter website uk best thesis statement writing services ca best presentation editing service uk esl expository essay writing services usa cheap university article example jesus third miracle the shipping news quotes top ghostwriter website for university professional critical essay on lincoln professional homework ghostwriting for hire for mba top mba essay writing services us best admission essay editor for hire for mba essay on letter from birmingham jail custom blog post writers website online best best essay editing service for college top rhetorical analysis essay editor sites for school top dissertation results writing site gb help with expository essay on hillary clinton custom paper ghostwriter service ca dui essay bibliography editor service uk popular rhetorical analysis essay ghostwriters for hire gb popular annotated bibliography ghostwriting for hire au custom home work writers site gb best bibliography writers site usa professional mba cover letter sample top term paper editor website online cheap report writer for hire ca write my management dissertation abstract pay to do botany dissertation conclusion esl speech proofreading service uk cheap cv ghostwriting service ca esl dissertation ghostwriters services online esl essay editing site cheap dissertation proposal ghostwriters websites online scholarship essay proofreading for hire a critique of utilitarianism bernard williams hamlet crazy quotes professional business plan ghostwriters services au esl curriculum vitae ghostwriting site for mba esl critical analysis essay writing site us cheap cheap essay writer sites for mba cheap paper proofreading services for school best critical essay writers site au pay for my classic english literature course work cheap critical essay proofreading services for college esl descriptive essay writer site for mba esl dissertation abstract editor service content writer websites au range finding robert frost analysis order cheap scholarship essay on lincoln hobbes theory of justice popular blog post editor site online dissertation abstract ghostwriting sites au algebra essay ghostwriting website personal essay writer websites ca best home work ghostwriter website esl essays proofreading websites for college custom papers ghostwriting services for school write top biography online custom creative writing proofreading websites gb popular custom essay writers sites for college esl school essay proofreading service us pay for custom home work top research paper writing service for masters popular blog editor sites uk help me write composition dissertation hypothesis best cover letter proofreading service for school best homework writers for hire for school cheap academic essay ghostwriting site us pay for speech problem solving custom college blog examples best phd problem solving custom annotated bibliography proofreading for hire uk custom papers ghostwriters for hire ca professional college essay writing site usa popular creative essay writers website online best home work writers websites for phd help me write esl descriptive essay on hillary descriptive ghostwriting website usa professional definition essay writing site for mba best dissertation proposal ghostwriters services for phd best masters essay editor websites au top cv writer for hire for university masters essay ghostwriters website usa best university essay writing service usa pay for my algebra speech popular papers ghostwriting site for school popular papers ghostwriting websites au phd essay proofreading website usa popular blog post ghostwriter sites au professional thesis statement writing websites ca top mba essay ghostwriter website online life in the suburb popular report editor services for school custom phd cv help top bibliography writer site ca top custom essay writers websites ca esl college dissertation methodology topics custom rhetorical analysis essay ghostwriting websites for college cheap creative essay ghostwriter website for phd professional school essay writing site us esl admission essay ghostwriter service usa solution to gender inequality custom homework ghostwriting websites au popular college essay ghostwriters website for masters custom essays writing services gb popular thesis editor for hire ca custom blog ghostwriters site for college custom personal essay ghostwriter websites for masters trigonometry essay examples professional blog ghostwriter websites us problem solving editing for hire gb popular school essay ghostwriting website ca cheap literature review ghostwriting sites uk top scholarship essay proofreading sites au popular descriptive essay writing for hire for phd top dissertation chapter writers sites for phd best resume writers website for school esl speech writing service for school best research paper writer website online help with popular thesis proposal online best content proofreading services gb best essay proofreading websites for masters custom academic essay writer websites ca top essays writers site for school pay to do culture speech best research paper writing website usa professional rhetorical analysis essay ghostwriters service for university custom biography editor websites online help with theater studies course work esl dissertation abstract editing service online drug abuse topics cheap rhetorical analysis essay writer websites au loyalty in the odyssey esl biography ghostwriter for hire for phd cheap academic essay writer service for masters help writing top persuasive essay online professional biography writer site custom university annotated bibliography sample pay to do best custom essay on civil war cheap business plan writers for hire gb help me write assignment pay to get custom essay on presidential elections scholarship ghostwriter for hire us popular research paper ghostwriter sites for mba popular homework writer websites for masters best blog proofreading for hire usa my life philosophy esl reflective essay editor site uk professional descriptive essay writers service for university popular research paper ghostwriter website uk cheap speech writers site for university cheap content writer services for masters custom dissertation abstract ghostwriter services uk professional writer for hire for mba esl research paper ghostwriter website for school cheap rhetorical analysis essay ghostwriters site for masters cheap term paper ghostwriting sites for phd order persuasive essay on shakespeare custom admission paper ghostwriters services ca esl papers writers service cheap papers proofreading service ca the evils of slavery buy rhetorical analysis essay on donald trump professional argumentative essay proofreading for hire for masters blog post ghostwriter websites us top cover letter writers sites ca antigone essays popular papers ghostwriter site au professional critical essay ghostwriter website for phd esl dissertation introduction ghostwriting service for mba professional descriptive essay proofreading for hire for school cheap college cv advice professional bibliography writing service for school best school essay writer for hire uk esl argumentative essay writers website uk best descriptive essay ghostwriter websites for phd best business plan ghostwriter websites write me professional cheap essay on brexit esl term paper proofreading sites us cheap problem solving ghostwriters service for college best dissertation conclusion ghostwriting for hire for university personal statement ghostwriting sites ca custom application letter proofreading site for mba best school report assistance legalsim custom biography writer sites for phd top dissertation chapter editor service for phd popular blog writers websites for mba cheap creative essay proofreading for hire online popular dissertation hypothesis editor site ca order descriptive essay on hacking custom creative essay ghostwriters services ca pay for education business plan tiberius and gaius gracchus top masters thesis proposal topics do my top reflective essay on usa professional content editor website for phd custom school report topic popular curriculum vitae proofreading for hire uk phd essay writing sites us cheap blog writers for hire for school custom case study ghostwriter websites for school esl scholarship essay writer service usa best presentation writing websites popular dissertation methodology ghostwriters site ca machiavelli and religion top admission paper proofreading website ca esl annotated bibliography editing website for college top persuasive essay editing website for university esl essays writers for hire help with remedial math case study peter elbow freewriting esl annotated bibliography ghostwriting services online cheap essay writer site for phd creative ghostwriter for hire au thesis ghostwriting service professional dissertation methodology ghostwriter website uk custom dissertation proposal ghostwriting websites for school esl personal statement ghostwriting sites custom term paper writers website for mba top phd school essay ideas do my classic english literature dissertation methodology top annotated bibliography writing sites for college best literature review writing websites for college custom term paper ghostwriter website for phd why i joined the army essay custom movie review writers website for university best persuasive essay proofreading for hire for college professional cheap essay writer website for masters top research proposal writing websites ca esl annotated bibliography ghostwriter for hire for school best course work editing sites online popular personal essay ghostwriter website for mba help me write tourism resume custom mba essay writing sites ca top resume writers services for mba professional school best essay examples best dissertation chapter ghostwriters service for college best rhetorical analysis essay writer website for university critical analysis essay writers sites ca custom reflective essay ghostwriters for hire usa top problem solving ghostwriters site au help writing management term paper popular creative essay editor for hire for masters professional dissertation proposal ghostwriter websites au custom critical thinking ghostwriters websites ca cheap book review ghostwriting websites custom descriptive essay writer services online personal essay ghostwriting service usa popular dissertation chapter ghostwriter sites persuasive and argumentative essay esl scholarship essay ghostwriter service au custom scholarship essay editor service online write nursing resume best custom essay ghostwriting services au custom dissertation hypothesis editing website ca best critical essay proofreading for hire ca custom content writer for hire for phd cheap dissertation writers sites poetry essay help top book review editing services for mba custom thesis statement writers service usa top critical analysis essay writer for hire ca custom school essay writer website uk best business plan writers for hire ca thesis proposal ghostwriters site au top thesis statement ghostwriter for hire ca pay to get english biography esl mba personal statement advice college ghostwriters for hire ca best assignment editing website for phd top assignment editor site ca esl presentation editor site ca custom dissertation chapter editing service for masters best dissertation methodology ghostwriter sites usa top phd essay editing services for school popular movie review editing site us cheap phd essay writers service for mba write my popular college essay on hillary content writers websites professional creative essay ghostwriting site for college popular report ghostwriting sites uk esl home work editor sites us esl research paper proofreading for hire au pay for my popular assignment online esl speech editor sites for phd pay for my law article social class essay cheap essay writing for hire online color in great gatsby the cranes meinke esl case study ghostwriters website ca popular mba blog popular college academic essay advice esl cheap essay writer service online essays on the industrial revolution professional dissertation conclusion editing sites for university help me write composition argumentative essay professional scholarship essay writers for hire au order education thesis best biography writers service for school best expository essay editor sites for college cheap dissertation writer site for school professional biography editing service for college esl cheap essay ghostwriters sites custom annotated bibliography ghostwriting websites uk gary soto oranges analysis professional writing websites for mba buy popular dissertation methodology online custom business plan ghostwriter websites for masters professional dissertation proposal editing websites for university popular admission paper editing sites au age of exploration dbq homework writers websites online professional biography editing site for masters professional creative essay proofreading websites gb pay for my dissertation chapter esl curriculum vitae editing sites for phd popular research paper ghostwriters site for university top phd analysis essay samples research paper on christianity professional dissertation conclusion editor services uk professional speech ghostwriter websites for phd cheap papers ghostwriter sites uk best blog ghostwriters for hire for college help with my speech resume best term paper writing sites for masters help with my cheap analysis essay online top application letter proofreading for hire health essay advice top papers ghostwriting website for phd popular persuasive essay writing sites esl resume ghostwriting site for university esl critical essay ghostwriters website online best course work ghostwriters website for phd custom blog post proofreading sites us top literature review writer service us best mba rhetorical analysis essay sample order anthropology creative writing custom cover letter ghostwriting sites ca custom speech writer service online esl resume ghostwriting service popular best essay writers website for phd best dissertation chapter ghostwriting for hire ca popular course work editor services au cheap critical essay editing site online esl report writer site for school top case study writer for hire usa cheap dissertation conclusion editing sites uk best thesis statement ghostwriters site ca top proofreading site usa top creative essay editor services art & architecture essay editor for hire cheap best essay writers for hire for college top speech editor sites for college cheap creative essay writers website for school rhetorical analysis writer website esl university dissertation abstract top dissertation introduction writing websites us cheap thesis statement writers websites uk cheap resume writers website for school presentation ghostwriter for hire uk professional phd essay editor website custom school article review popular personal essay ghostwriting for hire au best blog post editing website for school esl reflective essay ghostwriter service us custom creative writing editing websites top speech ghostwriter websites for college pay to get custom academic essay on hillary phd essay ghostwriter website usa popular dissertation methodology ghostwriting for hire au cheap thesis statement proofreading services for university esl critical essay writers sites us custom school thesis proposal topics best definition essay ghostwriter sites for mba top literature review editing site for college esl academic essay proofreading services gb best content ghostwriters site uk pay to write business report esl school book review assistance help with ancient civilizations content professional essays editing website for school professional essays writer for hire best papers writers site online cheap rhetorical analysis essay writers websites for school esl admission essay ghostwriter service us creative essay writing services au professional term paper ghostwriting site us professional thesis statement ghostwriter site for mba esl cover letter writing for hire uk custom definition essay editor services for college top cheap essay proofreading sites for masters professional academic essay editing for hire for university cheap article editor sites usa pay to write best university essay on hillary clinton the call jessie pope cheap application letter ghostwriting service for university professional term paper proofreading for hire au top article writer for hire for school custom literature review writer site usa esl movie review writer services for masters write me best cv popular thesis proofreading for hire for phd custom college essay writing services for university help with biology paper custom dissertation conclusion proofreading website uk help me write ecology bibliography best dissertation chapter writer website for phd popular creative essay writers service for college pay to get esl creative writing online top dissertation introduction editor site for university cheap dissertation results ghostwriting websites for masters pay for my economics thesis statement professional blog post writers service for school do my professional reflective essay on hacking cheap persuasive essay editing services cheap persuasive essay editing websites uk the adventures of tom sawyer essay custom dissertation results ghostwriters websites uk esl masters persuasive essay sample persuasive ghostwriter services usa cheap report writer services online popular thesis statement ghostwriters for hire for school pay to write engineering problem solving top dissertation conclusion editing services for university popular cv writing sites for phd custom assignment editing websites us professional thesis proposal writing sites for mba top bibliography editor sites pay to do scholarship essay on pokemon go write social studies dissertation critical essay writers websites gb best application letter ghostwriter websites for college help with business case study professional thesis proposal writers services ca college editor websites us cheap dissertation ghostwriting website us popular phd essay editing website au cheap academic essay editor site au kids talking to themselves best university definition essay sample admission essay on human resource management esl blog proofreading sites ca