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

Popular posts from this blog

matlab - Deleting rows with specific rules -

image - ClassNotFoundException when add a prebuilt apk into system.img in android -