asp.net - Passing Client Machine IP Address to SQL on Existing queries without adding as Parameter - SQL -
is there way client ip address (for auditing purpose) existing update, insert queries without adding parameter.
scenario: have asp.net application hosted on intranet , using subsonic executing queries. application has gone big many insert, update, delete statements. there requirement audit logs maintained. purpose have added triggers on tables insert, update , delete queries , audit table gets updated accordingly except ipaddress / client identity have made request. now, can't afford add 1 parameter each of these statements.
is there provision in sql or asp.net can store ip address or host name minimum efforts , changes in existing code.
seen suser_name, host_name think give me server ip address application hosted.
sorry english.
Comments
Post a Comment