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

All but one of the following entries are stale/don't exist and I just want them out. I've Ctrl-F'd the registry but to no avail. Any ideas?

enter image description here

share|improve this question
    
This url provides a really handy utility that should probably have been built into SSMS to begin with: walkersretreat.co.nz/files/SSMSMRU.zip –  rism Feb 3 '12 at 0:09
    
the url has changed - see my answer for updated url –  Mark Jul 17 '13 at 22:21

3 Answers 3

up vote 1 down vote accepted

Try deleting this file C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat or if you are on windows vista/Windows 7 look for a similar file in this folder (C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell)

Becareful as you will lose any customization that you have done.

Check this and this for more details.

share|improve this answer
    
Your first link was the answer for me on Win 7 / Sql Server 2008:SqlStudio.bin. Powershell use was necessary to avoid a total wipe of the user preferences. –  rism Feb 2 '12 at 23:59

For Sql Server 2012 Management Studio, this file has moved. It is now located at:

C:\Users\<username>\AppData\Roaming\Microsoft\
    SQL Server Management Studio\11.0\SqlStudio.bin
share|improve this answer
    
SSMS 2012 has the ability to remove servers built in without resorting to deleting this file. See my answer for link to blog post that explains how. –  Mark Jul 17 '13 at 22:23

I have written an open source UI to enable this (without losing other customisations) and posted it here: http://ssmsmru.codeplex.com/

Note that SSMS 2012 has the ability to delete servers build in. See here.

Over here and here are similar questions on SO. @arcticdev posted some code that I used in my UI

share|improve this answer

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.