Sqlserver method for clearing history

Time:2021-9-20

Make a backup before deleting.

When logging in to the database using SQL server, the logged in records will appear in the login box. The following is the deletion method:

SQL Server 2008
Delete the drive letter: \ documents and settings \ user \ application data \ Microsoft \ Microsoft SQL Server \ 100 \ tools \ shell \ sqlstudio.bin file\
Or: directly in the runtime
Win7 directly enter the following path in the address bar and delete the sqlstudio.bin file% appdata% \ Microsoft \ Microsoft SQL Server \ 100 \ tools \ shell

If SQL express 2008 is installed in Windows Server 2008 Standard Edition, remove it here:
Drive letter: \ users [someuser] \ appdata \ roaming \ Microsoft \ Microsoft SQL Server \ 100 \ tools \ shell \ sqlstudio.bin

SQL Server 2005:
Delete drive letter: \ documents and settings \ user \ application data \ Microsoft \ Microsoft SQL Server \ 90 \ tools \ shell \ mru.dat

SQL Server 2000:
Clear registry HKEY_ CURRENT_ USER\Software\Microsoft\Microsoft   SQL   Server \ 80 \ tools \ client \ prefservers \ corresponding contents.

Different systems may have slightly different paths. You can search the file name, which is roughly right. Even if it is deleted incorrectly, it can be recovered.