Create an Audit trail on SQL Server 2008 to trace all privilege users I need to create a trace of all the commands issued by members of SysAdmin or SecurityAdmin server Roles. I figured, I could use Profiler to do that but it will not comprise all the added members. I also checked the new Audit feature and yes, I can trace membership change on these roles but I will not get all their activity log. 

All I see now is to reactivate the trace with a DDL trigger on Server Roles membership change. 

Do someone brighter than me have a better idea ?
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.