Irfankhan1995 on Sun, 17 Mar 2019 04:42:48
What is simple and easiest way to know,who created/dropped/altered the database?
Thanks in advance.
Visakh16 on Sun, 17 Mar 2019 05:24:52
If you have audit log being captured somewhere you can get this information from it
Other methods are to get information from standard reports in SSMS or from default trace info
Yet another way is to query the log using fn_dblog function and get this info
see examples here
If transaction has been cleared from active portion of the log you would need to use fb_dump_dblog instead as explained here
AV111 on Sun, 17 Mar 2019 12:10:25
scott_morris-ga on Sun, 17 Mar 2019 12:34:30
Give those permissions to one and only one person.