>I have a new VFP 9 application using SQL 2005 database. Naturally we backup the SQL often, but I would like to know if there are any utility programs that will keep an audit long for all changes?
>
>Frequently the company will ask who changed that record and when. Or who changed it from X to Y (and that may be several changes ago).
>
>I just want an change audit log for ALL tables.
>
>THANKS
>Joel in Houston
Hi Joel,
I just also found and tried this script
http://vyaskn.tripod.com/tracking_sql_statements_by_triggers.htmMay be it can be helpful as well.
If it's not broken, fix it until it is.
My Blog