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
オークリーメガネ said
I am genuinely thankful to the owner of this web site who has shared
this fantastic paragraph at at this place.
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] How to find who altered my SQL Server Login […]
AdelaidWebber said
Hi to every one, the contents existing at this website are genuinely amazing for people knowledge, well, keep up the nice work fellows.