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??

link|improve this question

75% accept rate
feedback

1 Answer

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

link|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
feedback

Your Answer

 
or
required, but never shown

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