title: How to get the current website login name in SQL Server?
body: <p>I'd like to setup a trigger in SQL Server to log what the users do, like creating new products &amp; etc.</p>
  <p>How do I get the current website login username in SQL Server when they create new product in the front end? (Note: Not the username to login to database or the database user login that perform the insert/update/delete, it is the username to login to a website and that username &amp; password are stored in a table).</p>
  <p>For example, a front end user login to our website with username Janedoe and password 123456, then she creates a new product called ABC. In the database, this is recognize as an insert to a table called product, so how can I get that username Janedoe using SQL Server?</p>