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
sql-server
|sqlservermanagementstudio
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