Chen, this is more on having a user DOCUMENT why a change is made. So it will :
1) Find all changes
2) push them to another page for descriptions from user
3) Post change to change log.
4) write data to system.
It's more then a trigger that just records who and when. This is the WHY!
__Stephen
>Stephen,
>
>If you can, please post your code here! I also need auditing fucnction and thinking about doing it with SQL Server triggers, which can be time consuming.
>
>Chen
>
>>I coded this a year ago. If it's now part of the framework, great otherwise I'll post my code for you.
>>
>>__Stephen
>>