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’