title: Best way to implement an audit trail in SQL Server?
body: <p>I don't know if these requirements are standard or not but I'm wondering is there a solution out there which can do the following:</p>
  
  <ul>
  <li>For a specified set of tables keep a copy of a record prior to changing it in a audit version of the relevant table.</li>
  </ul>
  
  <p>I rather not have to code this for every table. I'm wondering if there is a solution you can install on top of SQL Server which will do this for you?</p>