title: Database Audit Log using Triggers - User information
body: <p>I'm contemplating using <code>AFTER INSERT, DELETE, UPDATE</code> Triggers to capture changes to one of my databases. One thing I want is to capture name of the user who made the change.</p>
  
  <p>Since I'm using a dedicated SQL account to connect to the database (from ASP.NET MVC), I don't believe <code>SUSER_SNAME()</code> will provide accurate information to me.</p>
  
  <p>Is there anyway for me to feed in the username from ASP.NET MVC side to the trigger? </p>
  
  <p>ASP.NET side is configured for Windows Authentication against Active Directory.</p>