I have write a trigger of one table to insert record of one table to another table at this time i have insert client host name or ip address
i have insert a first table record using one application.
i have use host_name or SELECT client_net_address FROM sys.dm_exec_connections WHERE Session_id = @@SPID but this return a server ip address or server name. i want to client ip or client system name to connected of my application within a trigger.
No i have one front end application within this application i have insert a record of one table. i have write the trigger of this table. the trigger is execute when insert record of table. i have write this code within trigger, so i want know which machine name is use this application to insert a record.