Hallo,

Is there any way to keep trace of what happen in a table? some tool that can handle any change in a single database table and any event such for exemple a record modification or deletion?

I'm working on a old database which has been filled with tons of scripts and procedures over the years so I really don't know how to compact them and get my work a little less harder. recently I've discovered that some procedure (and I really don't know which is) delete - appearantly - randomly some records from my db. I don't know if this procedure is called by a schedule (there are 3 terminal server users running all day) or by a human being ( : )! I have written some script to log events and scheduled tasks, but nothing seems to be helpful.

Any idea? Thank you in advance..

http://www.worldsync.com/fmDataGuard/