Post reply

SQL Server Management Studio 2005

  • July 15, 2009 at 6:23 am

    #155966

    I have got a very simple question, but I can not find the solution... Maybe some-one can helpt me out here, because I think that a lot of DBA's have the same problem.

    When I am working in a development and live enviroment, I would like the change the background color. For example, when the current tab is development, it should be white, and when I am connected to live it should be red...

    How can I arrange this? It is very dangerous, and a mistake is about to happen...

    I do not know if the is the right place on the forum, but I need to find a way...

    Thanks for your help!

    Best regards,

    Mischa.

  • July 15, 2009 at 7:00 am

    #1024996

    That kind of customization is not available in SSMS 2005. If it is it will be a 3rd party add-ons doing it for you, but I have not been able to find anything.

    If you have a licensed SQL Server 2008 server running you can load the SSMS for 2008 to connect to an SQL 2005 server. It has a new feature that allows you to color code your connections. Setting the color changes the color of the status bar within SSMS 2008 window.

    This link, shows how you do it for one connection. If you register your servers you can set the color for each server in the connection properties window.

    But again, you cannot load SQL Server SSMS 2008 unless you are licensed to use 2008 version of SQL.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • July 15, 2009 at 9:24 am

    #1025161

    But again, you cannot load SQL Server SSMS 2008 unless you are licensed to use 2008 version of SQL

    Mischa E.J. Hoogendoorn - You can purchase the DEVELOPER edition of SQL 2008 for less than $100 USD .... and have the fully functional SSMS.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 15, 2009 at 9:42 am

    #1025178

    You can use the SSMS coming with SQLExpress and it is almost fully functional.

    Unfortunately the coloured status bar works only for query windows opened with "New Query", but doesn't work when editing objects such as procedures or views. This feature could be improved a lot...

    -- Gianluca Sartori

  • July 15, 2009 at 10:14 am

    #1025209

    Thanks, I will try this, I have full msdn licences, so I have the developers edition here... Thanks for the advice! But I think that this could be improved a lot!

    Best regards,

    Mischa.

Viewing 5 posts - 1 through 4 (of 4 total)

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