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.

  • 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).

  • 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.

  • April 24, 2012 at 12:20 am

    #1477920

    Thanks Phil.

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

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