>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,

Please see if http://sqlserver2000.databases.aspfaq.com/are-there-tools-available-for-auditing-changes-to-sql-server-data.html and http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx can be of some help.