It’s a very vast topic and people became very interested to know who has been deleted the database from their working environment , Here I am using an undocumented process to get the information from box very quickly and hope there will be not any incedent to using this command as its only select statement.

SELECT Operation, SUSER_SNAME([Transaction SID]) As UserName,  [Transaction Name][Begin Time][SPID]Description
FROM fn_dblog (NULL, NULL)  WHERE [Transaction Name] = ‘dbdestroy’

will return result as and Username here for further analysis.

Advertisements
Comments
  1. good Script and it is working fine but in one case when you drop the database by T-SQL but if you deleted it from management studio by GUI it will not catch it
    thanks for your sharing your information

    Liked by 1 person

  2. Frank Boateng says:

    I tried this but I got only null values under the Username column. .your thoughts?

    Like

  3. THANKS for this article but we can add the hostname() colone to identify the name of the post which was the Drop operation

    Like

  4. I try deleting it from SSMS gui and still respond and found it, I do have a question since which versión and SP does this apply?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s