Get ip address of Delphi client calling a stored procedure

you can try the netstat command. Please check this link:
http://www.dbforums.com/microsoft-sql-server/1604725-how-select-current-client-ip-address-using-t-sql-command.html 

Thanks for the answer.

I can use
declare @host as varchar(20)
SET @host = (select host_name())
select @host

to get the host name, as suggested in your link, but I don't understand how to use the xp_cmdshell 'netstat -an'  command to get the ip-address.  Can I do this in SQL ?  pls provide sql code if you can

Here's an example using netstat -n
For more info on how to use netstat, just run this on the Windows Command Line (CMD): netstat /?
 

 
declare @temptable table (
row varchar(2000)
)
 
declare @getipaddress table (
proto varchar(3),
localaddress varchar(20),
Foreignaddress varchar(20),
state varchar(20)
)
 
insert @temptable 
exec sp_executeSql N'xp_cmdshell  ''netstat -n'''  
 
insert @getipaddress 
select	left(ltrim(row),3) as proto,
		substring(ltrim(row), 8, 19) as localaddress,
		substring(ltrim(row), 31, 19) as Foreignaddress,
		right(row, charindex(' ', reverse(row))-1) as State
from @temptable
where left(ltrim(row),3) = 'TCP'
 
select * from @getipaddress

Select allOpen in new window

Sorry for the later answer, I'm still waiting for an answer from the dba.  The problem is that I get an error executing:  
exec sp_executeSql N'xp_cmdshell  ''netstat -n'''

The error is:
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.

And I'm waiting for the dba to answer if he can do anything, or if this is just not possible (for security reasons).

Not sure what to do in the meantime, I can't really accept a solution when I don't know if it works.  Do I just answer later when I find out?

Thank you for this, I will send this to the DBA.  Now he has no excuse, everything done for him :)

Thanks for the (possible) solution.
I'll accept your solution ralmada since I'm sure it works, but the DBA at my company said that it is not an option to activate xp_cmdshell  :/
So I guess I'll have to find another solution, or just not do this at all.
Thanks for your help, and sorry for the late response.

See my last comment about the solution.