SQL Server: Who dropped a table, find out from Transaction Log

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing few steps to find out the transactions history for drop commands which executed in SQL Server.

There are many features for auditing and check the logging in SQL Server, but you can also directly read the transaction log and can get the necessary details.

Please check the below full demonstration of this:

Create a sample database and use it:

Create a sample table:
Check the object id of table and save it:
Now, drop the table:
Check the transaction id and user of that drop action:
Using below query, you can find only transaction id and username who dropped the objects. Later, you can use a transaction to know which object has been dropped.
Find out which object has been dropped:
Use above transaction id and see the details of dropped object.