title: How to keep an audit/history of changes to the table
body: <p>I've been asked to create a simple DataGrid-style application to edit a single table of a database, and that's easy enough. But part of the request is to create an audit trail of changes made, who made them, and the date/time.</p>
  
  <p>How might you solve this kind of thing?</p>
  
  <p>(I'll be using C# in VS2008, ADO.NET connected to SQL Server 2005, WPF and Xceed's DataGrid, if it makes any difference.)</p>