Post reply

How to change the SQL query editor color for different server connections.

  • April 23, 2012 at 6:34 am

    #254626

    hi,

    I am using SQL 2008.

    The issue is same old, we need different color scheme for every environment we use in SQL editor.

    For example:

    For Development: White

    For Testing : Yellow

    For Production : Green

    so this means SQL editor color should be connection dependent.

    I have seen many post where changing the color of status bar is explained but I want to change color of query editor window.

    Is this feature readily available.

    Thanks for your help in advance.

    Thanks,

    Shailesh

  • April 23, 2012 at 6:40 am

    #1477450

    Is this feature readily available.

    No. Status bar colours are the best you can get, as far as I know.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 23, 2012 at 6:44 am

    #1477453

    Go low-tech:

    Use three PC's or non-permanent marker.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • April 23, 2012 at 6:46 am

    #1477455

    Thanks for your response Phil.

    I think status bar is the only possible solution we have.

    Just wanted to try this in order to avoid human errors like truncting the table in unintended environment . <which has happened with us recently>

  • April 23, 2012 at 6:52 am

    #1477457

    shailesh.thapliyal (4/23/2012)

    Thanks for your response Phil.

    I think status bar is the only possible solution we have.

    Just wanted to try this in order to avoid human errors like truncting the table in unintended environment . <which has happened with us recently>

    A common enough occurrence, I am sure.

    Apart from implementing a more restrictive security model in production, you're always going to get human error. So far, the fact that I have a bright red status bar at the top of my screen (I moved it to make it more prominent) has been enough to stop me doing anything terrible (everything crossed).

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 23, 2012 at 6:57 am

    #1477462

    Status bar color seems to be best possible solution but I would like you to tell me how can I move my status bar on top of screen, currently it appears at the below. Moving it up will certainly make an impact on developers mind.

    Thanks again.

  • April 23, 2012 at 7:00 am

    #1477464

    The SSMS tool kit will do that for you, it assigns each server its own colour so will take some configuring to set the colours of each server.

  • April 23, 2012 at 7:17 am

    #1477471

    shailesh.thapliyal (4/23/2012)

    Status bar color seems to be best possible solution but I would like you to tell me how can I move my status bar on top of screen, currently it appears at the below. Moving it up will certainly make an impact on developers mind.

    Thanks again.

    Tools / Options / Text Editor / Editor Tab and Status Bar / Status Bar Location

    in SSMS.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 24, 2012 at 12:20 am

    #1477920

    Thanks Phil.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply