Showing posts with label Sql Log. Show all posts
Showing posts with label Sql Log. Show all posts

Wednesday, March 17, 2021

How To See Logs Of Dropped Tables From The Database in Microsoft SQL SERVER

 

Here, I will explain you how you can see logs of users.



Step 1 : First, create a new database with name "test".
Step 2 : Create a new table.


Step 3 : Now, go and drop the table by running the following command.


Step 4 : Now, select your database under Object Explorer and go to Reports >> Standard Reports >> Schema Changes History.


Step 5 : You will then see the schema change history. The report will show you who has dropped this table.



Finally, you can locate the user activity with the help of log.