THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Rambling DBA: Jonathan Kehayias

The random ramblings and rantings of frazzled SQL Server DBA

Clearing the Recent Servers List in SQL Server Management Studio`

Update: While I was away, Aaron Bertrand already blogged about this topic on the following link:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/03/18/managing-the-mru-list-for-the-connect-to-server-dialog-in-ssms.aspx

also thanks to Don Keily for pointing out in a comment that the file for 2005 is a different name, mru.dat, and not SqlStudio.bin. 

While debugging changes to the Extended Event Manager, I had a few nagging things like having to type in the server name to connect to for each and every test.  I set about configuring a most recent servers drop down in the application and wanted to model it off SQL Server Management Studio when I noticed that there is no way to clear the list from SQL Server Management Studio, which was something I wanted to incorporate in my own development.

It turns out that you actually can clear the list, but it requires that you remove the SqlStudio.bin file from the users application data path which generally is like the following for SQL Server 2008:

C:\Documents and Settings\<%username%>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell

or the following for SQL Server 2005:

C:\Documents and Settings\<%username%>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell

By deleting this file and restarting SQL Server Management Studio, the MRU List for Servers is cleared from the Connection Box.

Published Monday, April 20, 2009 7:49 AM by Jonathan Kehayias
Filed under:

Comments

 

AaronBertrand said:

April 20, 2009 8:32 AM
 

Don Kiely said:

Hi Jonathan,

The file you delete in SQL 2005 is mru.dat. In SQL 2008 it was changed to SqlStudio.bin.

Don

April 20, 2009 12:11 PM
Anonymous comments are disabled

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement