Stephen,
Thank you very much for sharing the code, which must have taken a lot of time for you to cook and taste.
Now I understand what your code can do that Triggers cannot.
Chen
>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
>>>
Chen Nan