>>Hi,
>>
>>I was wondering what others here think about storing changes to every record into some kind of audit trail table? Is this a good and reasonable design or waste of database storage?
>>
>>TIA.
>
>Hi Dmitry.
>
>As others have mentioned, it depends on your requirements. But with an audittrail, you have powerfull means to:
>1. To see who did change what record at what time
>2. Undo a change
>3. Travel back in time and recontruct the data at some point in time
>
>Walter,
I agree with your points, Walter. And this, I believe, makes the increase in database size worthwhile.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham