A personal repository of technical notes. - CSC

SSMS Connect to Server Server Name List

Problem
How do you remove the server name entries from the Connect to Server dialog box in Microsoft SQL Server Management Studio?

Solution for SSMS 2005
Delete the entire MRU list while SSMS is not running. When it starts up again, a new empty list will be created. As of this posting, I know of no way to remove individual items. MRU location:
%APPDATA%\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

Solution for SSMS 2008
Delete the entire settings file while SSMS is not running. WARNING: This file contains other settings.
%APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

References
About The Connect to Server Dialog - MSDN Forums
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=146430&SiteID=1

SQL Server Forums - SSMS drop down
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72477

How to get rid of unused servers in SSMS? - TechNet Forums
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=532146&SiteID=17

No comments:

Post a Comment