IF bulk data got inserted recently

Question

I want to know if bulk data got inserted recently in the database. How to check it?

Answer 1

Hi @Chaitanya Kiran ,

Through sys.fn_dblog you can see which operations have been performed recently.
If you see a large number of consecutive LOP_INSERT_ROWS in the Operation column, and the Transaction ID is the same, then it has a high probability of performing the BULK INSERT operation.
You can execute the following similar script.

SELECT * FROM sys.fn_dblog(NULL, NULL) WHERE operation IN ('LOP_INSERT_ROWS');  
SELECT * FROM sys.fn_dblog(null, null) where [Transaction ID] IN ('0000:00005a8c')  

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

SELECT *? Sorry, with the minimal context you give you in your question, the answer will be equally minimal.