title: Best way to detect which columns was updated when using triggers
body: <p>I have have a user table, that has |Firstname|Surname|DateOfBirth| ... and a few other columns. On that specific table i have a trigger on update that if someone changes any user values it creates an audit.</p>
  
  <p>My problem is, management want's a visual audit displayd int the following way:</p>
  
  <pre><code>DateChanged |Change                        |Details
  --------------------------------------------------------------------------------
  2010/01/01  |FirstName Changed             |FirstName Changed from "John" to "Joe"  
  2010/01/01  |FirstName And Lastname Changed|FirstName Changed from "Smith" to "White "And Lastname changed from "els" to "brown"
  2010/01/01  |User Deleted                  |"ark Anrdrews" was deleted
  </code></pre>
  
  <p>I beleive the best way to tackle this is by modifying the stored proc, but how can i instruct the trigger to record these kind of things?</p>