I have a Delphi program which uses Sql Server 2008. When it calls a stored procedure, I would like to get the ip address of the Delphi client (computer hosting the Delphi program) that called the stored procedure. Instead of the client himself sending the ip-address as a parameter. This is for security reasons.
Is this possible?
This doesn't help, it only gives the ip-address of the machine hosting the sql server.
select * from sys.dm_exec_connections