I like the "archive table" approach a lot. I had considered doing something similar to provide an audit trail for some entities (more like a "shadow table"). The archive table...

I often see a DateModified/ModifiedBy column pair on a table but all that tells you is who touched it last and when. Sometimes you'll also see a generic 'history' table...

I didn't take it as rudeness. It's actually nice to hear someone comment on this topic in an authoritative tone. I would have thought that this would be discussed somewhere...

Thanks, Remi. I figured that was probably the case, but I was curious if anyone had come up with a more elegant solution to the problem.