question

Chris 2 avatar image
Chris 2 asked

How to check specific row was deleted in transaction history

Hi,

Windows 2008R2/MS SQL 2012. I did a delete like:

delete from table where id = 103

was able to use fn_dblog to find delete activity and who did the deleted. Where I can find that row of 103 was deleted. Many thanks.

Chris

sql2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.