SQLTeam.com | Weblogs | Forums

SQL Server Audit Trail


#1

Hello Everyone.

We have a Production Database that holds a Lot of Data, one of our members reported to us that they have a discrepancy on their report. As we check it seems that one record was deleted, We have trace the record on our backup and it seems that it was deleted using SQL Statement. Is there a way to pin point the exact SQL statement that deletes the record and also the User and Date and Time it was deleted?

Thank you..


#2

You can use fn_dblog to find out who deleted data in SQL Server, take a look: http://dba.stackexchange.com/questions/4269/how-to-find-out-who-deleted-some-data-sql-server