MSSQLWIKI

Karthick P.K on SQL Server

How to find who altered my SQL Server Login

Posted by Karthick P.K on January 25, 2009

Do you know how to find who changed SQL Server login or Password?

Here is the way…..

SELECT [Transaction SID],suser_sname([Transaction SID]) as ‘Login Name’   FROM ::fn_dblog(default, default)   WHERE [Transaction Name]=’ALTER LOGIN’

 

 

Thanks

Karthick P.K

3 Responses to “How to find who altered my SQL Server Login”

  1. I am genuinely thankful to the owner of this web site who has shared
    this fantastic paragraph at at this place.

  2. […] How to find who altered my SQL Server Login […]

  3. Hi to every one, the contents existing at this website are genuinely amazing for people knowledge, well, keep up the nice work fellows.

Leave a reply to AdelaidWebber Cancel reply