Clear SQL Server Management Studio server name History

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

? 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.