Who did drop my SQL table?

The below queries could be used for finding more details on this unpleasant occasion.

SELECT top 100 [Transaction Id], [Begin Time], SUSER_SNAME ([Transaction SID]) AS [User]
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
SELECT top 100 * FROM fn_dblog(NULL, NULL) WHERE [Transaction Name] = 'DROPOBJ' 

No Comments

Leave a Reply