title: Best Solution to Create a change History for several SQL Tables
body: <p><em>I've searched a long time and don't found an solution here yet. Also this question is a little bit subjectiv. But i really need a good solution for this task.</em></p>
  
  <p>I have a table with Volumes, Security and much more informations.
  This data are daily changed.
  Now i need to <strong>keep this changes in a history</strong>.</p>
  
  <p>What is the best Solution to do this?
  Making a Second table with the same Structure and just insert the "old" data into this table?
  Or just making an additional parameter with Status? </p>
  
  <p>Making this server side with triggers?
  Or programmatically with a LINQ procedure?</p>