How to view log of Deleted Records in SQL Server

_Wade_
_Wade_ used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

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

Commented:

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
Commented:
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?)

Author

Commented:
Lowfatspread...

I'd like to go back a month.,
Commented:
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