How to update last modified user using windows auth info?
<p>I've a table <code>sales</code> containing sales records in SQL Server. I need a a column <code>modified_by</code> which shows the actor (user) of the last modification. Column <code>modified_by</code> should be filled by the user's ID related to the <em>Windows Authentication</em>.</p>

<pre><code>         id      content  modified_by
-----------  -----------  -----------
          1          foo          Tom
          2          bar         Jack
</code></pre>

<p>If Tom updates Jack's record, then for the record 2, the column <code>modified_by</code> will show <code>Tom</code> instead.</p>

<p>This UPDATE action should be done automotically by the server for every record modification. Can it be possible ? Should I use trigger to do it ?</p>