22 October,2012 by Jack Vamvas
Sometimes there is a requirement to clear down the Server Name items on the SQL Server Management Studio Connect to Server GUI.
The method used is slightly different for versions of SQL Server Management Studio. These are undocumented processes and there is guarantee they are available in future versions. It’s unclear what other data is deleted.
Shut down all SSMS instances on the server
Delete/Rename the file
For SQL 2005, delete the file: C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat For SQL 2008, the file location, format and name changed: C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin For Windows 7, it's in the following: SQL 2005: C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat SQL 2008: C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin