Clear SQL Server Management Studio server name History

? preface

During development, it is common to use SQL Server Management Studio to connect to local or remote SQL Server servers for a long time and may have some names that are not used or duplicated, andSQL Server Management Studio does not provide a quick way to delete. However, you can manually delete the sqlstudio.bin file to complete the deletion of the history list.

1. Delete SQL Server R2 history server name

1) Close the SQL Server Management Studio first. The sqlstudio.bin file is created again when you close SQL Server Management Studio , if you close it first.

2) Locate C:\Users\ user name \appdata\roaming\microsoft\microsoft SQL server\100\tools\ Shell\sqlstudio.bin file, delete it.

3) before deleting, you can back up this file or record the required server name and password.

4) :

1. before deleting

2. after deletion

2. Remove the SQL Server history server name

1) the same way as deleting SQL Server R2 history server names, except that the paths are different.

2) Road strength:C:\Users\ user name \appdata\roaming\microsoft\sql Server Management studio\11.0\ SqlStudio.bin.

Clear SQL Server Management Studio server name History