charles-600573 (10/26/2010)
I am not sure I am missing something here.You state:
"This example tracks the progress of auditing in just one table. All the tables in the database, without exception, operate on this same principle"
mmm.
Surely if you delete a record from the AdmUser Table (hopefully the constraint won't let you), it would mess up.
Cheers
Certainly you can put business rules in your app that prevent you from deleting things that should not be deleted. But that is (properly) up to the business rules, not the database.