About the author

Steven Harmansteven harman :: makes sweet software with computers!

For recent posts and more about me, scroll to the bottom.

Sponsors

Subscribe

  • Subscribe to my feed. via RSS
  • Subscribe via email via email

SQL Server 2005 Management Studio - Clear Recent Servers List.

If you've used the Microsoft SQL Server 2005 Management Studio (SSMS) very much you probably make heavy use of the "Server name" drop down list to quickly connect to SQL Servers that you use on a regular basis.

SMSS - Server Name dropdown

I use that sweet drop down all the time - but then on any given day I log into up to half a dozen (or more) SQL Servers. Trying to keep all of those server addresses, usernames, and passwords is a job in it's own right! Microsoft knows this, and that's why SSMS will remember all of your past connection settings.

As you can imagine over the course of time (weeks, months... whatever) this list of "recent connections" can get quite long!

How Do I Clean Up the List?

Unfortunately the GUI doesn't provide a mechanism to clean nor clear the list, so you'll have to do a little browsing through your file system. After a little Googling I found this tip which also explains how to clear the list for SQL Server 2000 (via some Registry hacking).

In case you don't want to click through and read that article, Matt says

All you have to do is delete
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat.

Just remember, once you delete that file all of your previous connections will be lost. So make sure that you have any necessary IP addresses, usernames, and passwords that you'll need to reconnect to your favorite/most used SQL Servers.

What others are saying.

# SQL Server 2005 Management Studio - Clear Recent Servers List.
Gravatar DotNetKicks.com
Nov 07, 2006
You've been kicked (a good thing) - Trackback from DotNetKicks.com
# SQL Server Management studio - Connect To Server, remove entries from list
Gravatar Braulio_Malaga
Apr 12, 2007
SQL Server management studio has a very good feature it remembers that last X server that you connected...
# re: SQL Server 2005 Management Studio - Clear Recent Servers List.
Gravatar Aart
Jan 24, 2008
In case you can't find "mru.dat" in the "Shell" folder, try the C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

Cheers,

Aart
# re: SQL Server 2005 Management Studio - Clear Recent Servers List.
Gravatar ninjacodermonkey
Apr 29, 2008
Thanks... helped me out of a bit of a pickle. ;P
# re: SQL Server 2005 Management Studio - Clear Recent Servers List.
Gravatar Mike
May 14, 2008
Thanks, this was a great help! Note that on Vista the file can be found at

C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell
Comments have been closed on this topic.