Some of our clients want every change to a table logged. We are in the middle of upgrading our applicaiton to SQL right now. I know that SQL Server has a transaction log file. Is there a way to view the information in the log file and report back what has been changed?

We would like to somehow report it back in a foxpro report, because they won't understand tables and field names. They would want something like "What has changed on Sales Order 10" We would need to query the log to only pull the tables that relate to our sales order tables and limit them down by the correct field in the table. Is this possible or do we need to add triggers to all our tables?