title: Creating a "date updated" column in MS SQL?
body: <p>Is there any simple way to create a column in MS SQL that will track the last time a record was updated?</p>
  
  <p>I would like to have two fields. One to track when the record was created. That one is simple. Create a datetime field and set its default to getdate(). However the second field seams to be a bit more tricky. I want it to have the latest date (and time) the record was modified.</p>
  
  <p>My options are:</p>
  
  <ul>
  <li>Include getdate() in every update statement - not an option, these tables will be accessed from MS Access</li>
  <li>Allow updates only through an SP. - not an option, these tables will be accessed from MS Access</li>
  <li>Create triggers for each table - the DB is recreated on many machines and I am afraid it will conflict or be forgotten or get out of synch.</li>
  </ul>
  
  <p>Are there any other options?</p>