User Id :    Password :      New Member   Forgot Password  
 
How to cleare login history of user from sql server
Description How to cleare login history of user from sql server   No. of Views     3009
  Rating     0
Author Najmul Hoda   Posted On     17 Oct 2010
Tags SQL SERVER,SQL SERVER : How To    

Sample Code   Download Code

Introduction

Yesterday I need to clear the user login history from the sql server 2005. After googling alot I got a solution.

Go to  C:\Documents and Settings\[Username]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM and delete mru.dat.

It contains the login/connection history of the user. When you restarts SQL server next time it will automatically create new file with the same and you will get empty login history.

 

 

About Author

About Author He is a team lead, having 8+ years of experience. He loves writing technical article for .Net developers. Najmul Hoda
No Photo
 
Country United States
Company BirlaSoft
Home Page http://www.magixchat.com

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

   
Write your comment here.
Comment
Verification Code