>Hello,
>
>I have to implement a log functionality for all the changes made through a webapplication in a SQL Database. The web application is written with MereMortal 3.5
>
>In the first step the logged in user, a timestamp and the changed data should be logged. In a second step in the future it should be possible to restore some of the changed data.
>
>The current idea is to have 2 extra tables for this audit trail. One table (Audits) contains the information of the username, timestamp, tablename (for the name of the table where the data was changed) and the PrimaryKey of this table. And the XML of the saved/deleted dataset
>The second table (AuditRecords) contains the Columnname and the old and new value of the changed record. The second table has as a foreign key the primary key of the first table.
>
>My question is now where to plug in this functionality in the MM BusinessObjects?
>The current idea is to use the CallStateChange Event, and to look for the mmBusinessState.Saved and mmBusinessState.Deleting. But not every datarow is passing this function, so some changes are missing.
>
>Is there any other and better solution?
>
>Thanks for your answers
>
>With regards
>Thomas

Thomas,

In my opinion Audit Trail function belongs to the database. You can implement it as trigger in SQL Server database.