title: Get the UserID of the current logged in User in asp.net default membership provider
body: <p>I have two tables </p>
  
  <pre><code>Employee (EmpID, Name, UpdatedBy, UpdateDate)
  EmpContact (ContactID, Contact,EmpID)
  </code></pre>
  
  <p>I am trying to create a trigger which update a Employee table fields <code>UpdatedBy,UpdateDate</code>. when contact is added or modified i want to update Employee's <code>UpdatedBy and UpdateDate</code> fields  (These two tables have different asp.net-mvc views).
   I am using default membership provider to authenticate the user.<br> So my question is how <strong>can i get the current logged in user in trigger who initiated the insert, update or delete. Is there any way i can know which asp.net user id initiated the transaction within the TRIGGER</strong></p>