How to view log of Deleted Records in SQL Server

_Wade_ used Ask the Experts™
I have an application using SQL Server as a backend. Somehow, when records are deleted from a table, is there a log of these transactions that would give me any info about when/who deleted the records?

How do I go about viewing this?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ephraim WangoyaSoftware Engineer


Create a delete trigger on the table you want to log. When a record is deleted you can use the trigger to store the required fields of the record on a log table
Top Expert 2011
no there is no automatic method for what you desire... you need to implement and audit trail to identify what you are after... ewangoya suggests 1 method...

alternatively  there are some tools that can get you this sort of information, (how far back do you want to go?) look for Redgate  (log browser?)



I'd like to go back a month.,
or, use apexsql's apexsqllog

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial