I agree totally. I would recommend adding an audit table, and keep track of changes there by using a trigger to insert the important information to the audit table (who, what, when).

Then you can just do a select when you want to find the information.