Post reply

How to remove server names from drop-down list of servers?

  • March 21, 2016 at 9:23 am

    #314218

    In [SSMS]/[Connect]/[Database Engine]/[Server Name] it displays a drop-down list of servers that I have ever connected to. Some of these entries are outdated. How can I remove them?

    Thanks

  • March 21, 2016 at 9:26 am

    #1866501

    Connect to lots of other servers so that the old ones disappear, I suppose. Or hack the registry to get rid of them. You'll probably be able to find them with a search. Don't forget to back up your registry first!

    John

  • March 21, 2016 at 9:32 am

    #1866505

    Thanks for advise, but unfortunately I don't have so many servers to connect to in order to push out the old ones.

    And hacking the Registry I think is rather dangerous. Is there any tool or GUI that can prevent me from making wrong changes that can lead to disaster?

  • March 21, 2016 at 9:36 am

    #1866510

    http://stackoverflow.com/questions/1059105/how-to-remove-server-name-items-from-history-of-sql-server-management-studio

  • March 21, 2016 at 9:42 am

    #1866512

    open the dropdown so it shows all your history of connections.mouse hover over an item so it is highlighted, but DO NOT mouseclick/SELECT it.

    while the dropdown is still open, and one item is highlighted, click the "delete" key

    Repeat as necessary.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 21, 2016 at 10:03 am

    #1866523

    Great! Finally it worked for me. Thanks a lot.

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

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