SQL Server Management Studio Connect to Server List Editing

Posted by Paul Farry on Server Fault See other posts from Server Fault or by Paul Farry
Published on 2010-02-18T05:34:53Z Indexed on 2010/03/16 0:00 UTC
Read the original article Hit count: 328

I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no longer in use, without having to set them all up again.

I know that the C:\Users\*\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat can be deleted and this will remove ALL the entries, but is there anyway to just delete some of them?

(Coding info)
I looked at the file and it is a serialised blob from the Microsoft.SqlServer.Express.ConnectionDlg.dll (Class Personalization) in the Appplication directory, but all the methods are private. So I can't just create an instance of this and then call Remove on the entries.

Update I have written an Article on CodeProject explaining How this can be achieved. http://www.codeproject.com/KB/vb/AlterSQL2005MRU.aspx

© Server Fault or respective owner

Related posts about sql-server

Related posts about sqlservermanagementstudio