I worked on an application where by all tables in the database had audit information. The audit information contained Created By, Created Date, Updated By, Updated Date. All of the stored procedures that added or updated any table posted the audit information. It was quite effective and had a number of very useful benefits. Now not all applications can carry the extra burden of this type of audit information so consider some sort of journal to log important or critical updates.
The above mentioned application also had an audit feature that identified old/new information that was being modified in certain tables. Again, a bit of overhead but it fit the business needs.
Kurt W. Zimmerman
New York, NY