Who deleted my sql table rows?

Posted by vikasde on Stack Overflow See other posts from Stack Overflow or by vikasde
Published on 2010-05-31T19:46:32Z Indexed on 2010/05/31 19:53 UTC
Read the original article Hit count: 193

Filed under:
|

I have an SQL table, from which data is being deleted. Nobody knows how the data is being deleted. I added a trigger and know the time, however no jobs are running that would delete the data. I also added a trigger whenever rows are being deleted from this table. I am then inserting the deleted rows and the SYSTEM_USER to a log table, however that doesnt help much. Is there anything better I can do to know who and how the data gets deleted? Would it be possible to get the server id or something? Thanks for any advice.

Sorry: I am using SQL Server 2000.

© Stack Overflow or respective owner

Related posts about sql

Related posts about trigger