Chuck,
The problem with the transaction log is the next request you get will be reports on the changes. I did a system a couple of years ago that used triggers to generate the change log. The system would track every with the old value and new value for each change. I also generated some xml (sort of) that was stored in text column with all the old values of all the columns in a table. All the changes were stored in one table with the table name changed, primary key, date changed and the user doing the changes. I don’t use MSSql server but I don’t see a reason why you can’t do this.
Hope this helps.
>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only