>Frank,
>
>I have made multiple attempts to do this myself, and in the end, it is my opinion the best way to track changes is to use database triggers as opposed to code in the framework. I also believe that mrroring tables (or having a copy of each table for audit purposes) is not desirable. I would have two audit tables (one header that tracks the table name and date/time and one detail table that has the column name with before and after image) that tracks the changes. This way you can track all changes in one place.
>
>Take a look at the following audit solution:
>
>http://www.krell-software.com/omniaudit/
>
>
>You can download and try it out for 30 days. It uses the structure I mention above and you can selectively choose the tables you want to audit. The price is less than $500 for a single user. By the time you research, write, test and implement your own solution, I think you would eventually say the cost is well worth it. It will take you less than a half hour to set up and implement.
>
>I encountered one problem with this, however. And that is the setting the user who made the changes. The company states you can run a stored procedure before saving any data that would set the user name for the audit, but I was never able to find out where in the MM.NET framework code I could run this and have it hold its value (due to the stateless nature of web apps).
>
>
>If you can figure this out (assuming you try this out yourself), please let me know.
>
>
>>
>>
>>Thanks Timothy (that sounds so formal) :)
>>
>>So there's no way to do this in the database itself? In my VFP applications I use triggers to update other tables storing xml values of the changed data. I see various suggestions on SQL Server sites to use "mirrored" tables, but they all use SUSER_SNAME() to get the user name, but I *think* that mm.net uses impersonation to access the database so that will store the wrong user. Or am I off target there and it will get the right user? It's been so long since I did the database access part of this project that I can't remember now :)

Thanks Bob,

unfortunately I have a lot of time and a little money so can't buy this application. Something I have built into the system already may do all the client wants so I am awaiting their feedback.