Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio:

enter image description here

Where are those names stored?? Is there any way to clean up that list and remove some entries??

share|improve this question

1 Answer 1

up vote 3 down vote accepted

For SQL 2005:

C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

For SQL 2008:

C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

So...

  1. Shut down all instances of SSMS
  2. Delete/Rename the file
  3. Open SSMS

Edit: on MS Connect https://connect.microsoft.com/SQLServer/feedback/details/424800

share|improve this answer
    
Thanks - there's no way / utilty to peek inside those files and selectively delete out a single entry or two?? –  marc_s Jun 9 '11 at 7:20
    
dunno. never tried it.. :-) –  gbn Jun 9 '11 at 7:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.