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.

Hi,

this is the only way to get the information. prior to the DMV you had
to retrieve the information from XP_cmdshell:


http://www.sqlserver2005.de/Articles/3/


HTH, Jens K. Suessmeyer.


---
http://www.sqlserver2005.de
---

Default paramenters in Functions
Deleting a Log file and recreating it...
Transaction log file gets very big on weekends compared to daily
permission over excute SP
delete old files
Backup Database remove inactive/replication
Read CSV file - Save Columns into Rows
Export Column
password sql 2005
SQL Trace?