title: SQL Server 2008 - On Insert/Update Trigger that copies values to another table?
body: <p>I have these two tables: Tasks and TasksHistory, from the name you can guess that I want to create a history of everything that's been going on in Tasks. So, every new row inserted or updated needs to go into the history table, just ignoring when it's deleted, keeping the row safe in history. My idea is that history be an <strong>exact replica</strong> of the original table.</p>
  
  <p>How can I achieve this?</p>