title: How to capture truncate statement information in SQL Server 2012
body: <p>I would like to capture the truncate statements information along with the user/Login information for all database in my production server.</p>
  
  <p>Example: </p>
  
  <pre><code>Use mydb
  go 
  truncate table deleteme_table
  </code></pre>
  
  <p>I would like to capture the information into the table like the below </p>
  
  <pre><code>Table           Operation   Database    Login              Time
  deleteme_table  Truncate    mydb        sandeep.pulikonda  17-12-2014 17:50:00
  </code></pre>
  
  <p>If the above scenario is not possible please suggest possible ways to capture it</p>
  
  <p>I am using SQL Server 2012 Standard version. So granular level audit are not supported for that version.</p>