A personal repository of technical notes. - CSC

SSMS Connect to Server Server Name List

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

About The Connect to Server Dialog - MSDN Forums

SQL Server Forums - SSMS drop down

How to get rid of unused servers in SSMS? - TechNet Forums

No comments:

Post a Comment