asked
Find who deleted the rows in table in sql server
i have a database configured simple recovery model with daily full backup at 12:00 PM IST it has table name called 'Blod' with 50 records and another table called 'comment' it has the foreign key reference to 'Blod' table with deleted cascade ,some one has deleted the record form 'blod' table two days before, all the detail form both the tables are deleted ,now i need to find out who deleted the record i used fn_dblog to find out but it does not have the record since it has a full backup all the logs are truncated ,what is the way to find who deleted the record? anyone kindly suggest
You will not be able to find out who deleted the records unless you have custom logic like triggers etc which logs changes. If this is something you want to track for the future, you should configure Auditing in SQL Server.
17 People are following this question.
