In a database I created an audit table in which, e.g., I insert one record
for each INSERT statement made on another table (via a trigger).

My problem is to recover remote IP address of the connected client which
does the INSERT.

I tried to use DMV sys.dm_exec_connections because it contains a "client_net_address"

field: it was just what was searching for.
But, unfortunately, this DMV requires VIEW SERVER STATE permission, which
is not assigned to any user.

May you tell me how can I solve this problem, avoiding to assign that permission
to everybody?

Thanks all.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution