title: Tracking changes to database rows (SQL Server)
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/793643/auditing-sql-server-data-changes">Auditing SQL Server data changes</a>  </p>
  </blockquote>
  
  
  
  <p>My requirements demand for each row inserted and updated in the database to track who made the change (creator/modifier), when the record was created and when it was modified. I have guids for row IDs in all tables, so I thought I would come up with a table <code>rowdata</code></p>
  
  <p><code>rowdata</code>: <code>created (datetime)</code>, <code>modified (datetime)</code>, <code>createdby</code> (string or user id), <code>modifiedby</code> and maybe <code>summary</code> column (string, summary of changes)</p>
  
  <p>and then put some insert/update triggers in place. Do you think is fine or is there another wa (maybe out-of-the-box one)?</p>
  
  <p>My dev environment is .NET 4, so if you think of other options that might come into question, please tell.</p>