Post reply

Connect to Database Engine Box

  • November 3, 2010 at 9:11 am

    #242602

    Hi,

    I have two aesthetics questions. We have a ton of boxes that we use for testing and what not. Is there a way in the Connect to Database Engine box to remove old environments from the Server Name drop down list? I tried just deleting and right clicking the old box names, but that did not work.

    Additionally, our server names are kind of quirky and long. Is there a way to give them aliases in that same Server name drop down list?

    Any help is much appreciated.

    Thanks,

    Matt

  • November 3, 2010 at 9:20 am

    #1246084

    hi , i am new user

  • November 3, 2010 at 10:10 am

    #1246139

    You need to delete a particluar file, which will remove all listed servers - "It turns out that you actually can clear the list, but it requires that you remove the SqlStudio.bin file from the users application data path which generally is like the following for SQL Server 2008:

    C:\Documents and Settings\<%username%>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell

    or the following for SQL Server 2005:

    C:\Documents and Settings\<%username%>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell

    By deleting this file and restarting SQL Server Management Studio, the MRU List for Servers is cleared from the Connection Box"

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • November 5, 2010 at 12:35 pm

    #1247289

    This comment helped remove the server list. Thanks.

  • November 5, 2010 at 12:36 pm

    #1247290

    Good to hear, glad I could help.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

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

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