title: How to get all the transaction logs (insert update delete) for a specific table in SQL Server 2008
body: <p>I want to get all the transactions applied on a specific table in SQL Server 2008.  </p>
  
  <p>I found the last time a table was updated using this script:</p>
  
  <pre><code>SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
  FROM sys.dm_db_index_usage_stats
  WHERE database_id = DB_ID( 'DBName')
  AND OBJECT_ID=OBJECT_ID('tableName')
  </code></pre>
  
  <p>I want to know all the transactions (Inserts, Updates, Deletes) for that table, and their datetime, and the query applied.</p>
  
  <p>What is the best way to do this?</p>