Home Forums SQL Server 2008 SQL Server 2008 Administration Using ::fn_dblog() to find who deleted the rows in a table. RE: Using ::fn_dblog() to find who deleted the rows in a table.
Lynn Pettis
SSC Guru
Points: 442467
More actions
December 26, 2012 at 5:41 pm
#1571719
If it is important to know who did something, you should look at setting up auditing so that you can capture this in the future. You may also want to look at CDC if you need to capture the actual changes to data.