Create an Audit trail on SQL Server 2008 to trace all privilege users
You might be looking for something like Change Data Capture.


  Change data capture is designed to capture insert, update, and delete
  activity applied to SQL Server tables, and to make the details of the
  changes available in an easily consumed relational format. The change
  tables used by change data capture contain columns that mirror the
  column structure of a tracked source table, along with the metadata
  needed to understand the changes that have occurred.
  
  Change data capture is available only on the Enterprise, Developer,
  and Evaluation editions of SQL Server.