title: Get Connection's IP Address in SQL Server without VIEW SERVER STATE permission?
body: <p>Is there a way to get the IP Address of a connection without the user being in the SysAdmin Role or being granted VIEW SERVER STATE? One of these is required to issue this query:</p>
  
  <pre><code>select client_net_address from sys.dm_exec_connections where session_id = @@spid
  </code></pre>
  
  <p>I want to log the IP Address inside an Instead-Of Trigger, but I don't want to go granting the VIEW SERVER STATE permission to all users.</p>
  
  <p>Thanks for any suggestions.</p>
  
  <hr>
  
  <p>Followup 2013-10-05:
  Thanks for the various comments. What are the dangers in granting VIEW SERVER STATE to all users?</p>