title: Find hostname of user that fired trigger
body: <p>I am using a script to make and audit table for a table in a database. I have triggers for INSERT, UPDATE AND DELETE. Currently it writes suser_sname() to one of the fields in the audit table.</p>
  
  <p>My problem is that every user has the same login name. By executing sp_who2 I can see that the HostName is different for each user.</p>
  
  <p>However, when I try to use HOST_NAME() it seems like I get the IP address for the server instead.</p>
  
  <p>What function can I use to get the HostName of the user who fired the trigger?</p>