title: how to pass current logged in user username to SQL Trigger with forms Authentication
body: <p>i am new to MVC  framework and trying to build an web app with VB. I am using Active directory for authentication with forms authentication &amp; sql server for Managing the roles. I want to create a trigger by which if any web logged in user insert, delete or update the exsting data should be copied to another table table with the username who had done so.</p>
  
  <p>I am using sqlexpress 2008 R2  with iis 7.5, My apppool is configure for integrated managed pipeline mode. </p>
  
  <p>require any help on how to pass the User.Identity.Name from wbsite to sql, it is always passing the system user NT AUTHORITY\SYSTEM in system_user in sql.</p>