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

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

I need to import mysql 5.1 to 5.5? -

Java, Hibernate, MySQL - store UTC date-time -