Auditing Deletes in table

[Tekreader]

Helo Sql friends,
Can anyone tell me is there a way to audit Deletes in a table in Sql server 2000 or 2005 databases.

In production database some records are deleted by some one,I can not revoke the write permission, But I want to audit who is deleting the records.Can anyone tell me how to find this?

Thanks

 

[chrissie1]

I would use a trigger, but perhaps that is personal.

Christiaan Baes
Belgium

My Blog

 

[SQLDenis]

use a delete trigger

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[chrissie1]

I was first.

Christiaan Baes
Belgium

My Blog