How to remove SQL Server name from drop down in management studio#


In SQL Server 2008/2005 Management Studio, during the login process there is an input text box called "Server Name". This is a drop-down which stores a history of servers that you have previously connected to.
This article shows how to remove a server from the drop down history

  • Close the Management Studio Application (SSMS)
  • Delete relevant file as follows:
For SQL 2005:
C:\Documents and Settings\<CURRENT-USER>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
For SQL 2008:
C:\Documents and Settings\<CURRENT-USER>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
  • Reopen Management studio.

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-30) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 9520

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1