Method for clearing historical records, SQLSERVER history

Source: Internet
Author: User

Method for clearing historical records, SQLSERVER history

Back up data before deletion.

When using SQL Server to log on to the database, the logged-on records will appear in the logon box. The following is the deletion method:

SQL Server 2008
Delete the drive letter \ Documents and Settings \ User \ Application Data \ Microsoft SQL Server \ 100 \ Tools \ Shell \ SqlStudio. bin. \
Or: running the database directly
In the address bar of win7, enter the following path to delete the SqlStudio. binfile % AppData % \ Microsoft SQL Server \ 100 \ Tools \ Shell.

If SQL Express 2008 is installed in Windows Server 2008 Standard Edition, delete it here:
Drive letter: \ Users [SomeUser] \ AppData \ Roaming \ Microsoft SQL Server \ 100 \ Tools \ Shell \ SqlStudio. bin

For SQL Server 2005:
Delete drive letter: \ Documents and Settings \ User \ Application Data \ Microsoft SQL Server \ 90 \ Tools \ Shell \ mru. dat

For SQL Server 2000:
Clear the content of the Registry HKEY_CURRENT_USER \ Software \ Microsoft SQL Server \ 80 \ Tools \ Client \ PrefServers.

Different systems may have slightly different paths. You can search for the file name, which can be roughly the same. You can restore the file even if you delete the file incorrectly.


How to clear the history of word? (Resolved)

For example,--C: \ Documents ents and Settings \ Administrator \ Application Data \ Microsoft \ Office \ Recent can only be understood. If LZ seems to be playing white--clear, use the following method in Word, you can directly Delete the recently used history using the following method:. select the "options" command in the "Tools" menu, and the "options" dialog box appears. B. Select the "General" tab, deselect the "list recently used Files" check box, select the "list recently used Files" check box, and enter "0" in the number of files box ". C. Click "OK.

How to clear historical browsing records on Baidu

Two methods:
1. Right-click the IE icon on the desktop-> Properties
General Tab
Click "Clear history" in "history ".
Then "OK"
2. C: \ Documents ents and Settings \ Administrator \ Local Settings \ History
Delete all the items in it

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.