How to identify who has created or dropped table in SQL Server DB?

Sometimes we strange to find out who has created, modified or deleted tables in our Database. So, here it is very easy to find out who has made changes in our DB?

Just follow few steps:

Step 1: Chose your DB and go to reports and click on Schema Changes History




Step 2: You will get the below Schema Changes History reports

If you want to check out just go in your DB and drop any tables. And see the report.

Hope you enjoy the solutions.

Comments