How to remove “Server name” items from history of SQL Server Management Studio

電腦小知識

For SQL 2005, delete the file:

C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server90ToolsShellmru.dat

For SQL 2008, the file location, format and name changed:

C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin

How to clear the list:

Shut down all instances of SSMS

Delete/Rename the file

Open SSMS

In Windows Server 2008 standard with SQL Express 2008, the “SqlStudio.bin" file lives here:

%UserProfile&MicrosoftMicrosoft SQL Server100ToolsShell

For SQL Server 2012 Management Studio, this file has moved. It is now located at:

C:UsersAppDataRoamingMicrosoft

SQL Server Management Studio11.0SqlStudio.bin

, ,