Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

Top Categories · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

How to clear the history list from the "servername" field of SSMS Connect-to-server dialog box?

Jan 20 2011 4:57AM by Charmy Cook   

Hi Nakul,

I read your SSMS blogs at beyondrelational.com and found them very interesting.

Recently, I came across a situation where I wanted to remove entries of "server name" from history of SQL server management studio.

I would like to know how can we remove ip/servername from drop-down box "server name" that comes up in the "Connect to Server" dialog box while we connect to SQL Server.

Submitted under: Microsoft SQL Server · SSMS ·  ·  · 


Charmy Cook
793 · 0% · 36

3 Replies

  • Hello, Charmy!

    Thank-you for your kind words. It is good to know that my blogs helped you to get a little bit closer to Microsoft SQL Server.

    As to the problem that you mention, you are not alone. This has been on my wishlists also ever since SSMS was introduced with SQL Server 2005. The problem has been reported to Microsoft and is documented at: https://connect.microsoft.com/SQLServer/feedback/details/424800/ssms-expose-connect-to-server-mru-list-to-users#details

    Workaround: As a workaround, here is something that you can try:

    1. Navigate to : %appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell (For SQL Server 2008) OR %appdata%\Microsoft\Microsoft SQL Server\90\Tools\Shell (For SQL Server 2005)
    2. For SQL Server 2008, delete teh SqlStudio.bin file. For SQL Server 2005, delete the mru.dat file.
    3. You should now be all set

    I hope that the above information helped you, and that you will continue to regularly share your feedback to the community.

    As I always say,

    Be Courteous. Drive Responsibly.

    commented on Jan 20 2011 5:57AM
    Nakul Vachhrajani
    4 · 33% · 10680
  • Hello, Charmy! Did the above answer your query satisfactorily? The reason I am asking is that I am still seeing this as "unanswered", and wanted to know if there is anything else I can help you with.

    commented on Apr 2 2011 5:30AM
    Nakul Vachhrajani
    4 · 33% · 10680
  • Hi Nakul,
    Yes it answered my question. Thanks a lot. I marked it as answered.

    commented on Apr 5 2011 1:53AM
    Charmy Cook
    793 · 0% · 36

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]