FWIW (bit late now, but perhaps worth considering for next time) we have Triggers on all our tables (all the ones that matter) for UPDATE and DELETE that store the "before" data into an audit table (each table has a "parallel" Audit Table, same columns as main table but with additional Date/User columns).
Useful for accidents, diagnosis, fraud investigation ... etc
Data deleted - how to tell when (using .trn)
Posted - 11/11/2010 : 07:15:12
