Skip to Content
0
Former Member
Jun 11, 2014 at 06:42 PM

how to get client IP or host name or program name in stored procedure?

1178 Views

Suppose I run a sp for sybase ase. Firstly I need to connect to ase with specific loginname, then I have spid for this session. sp_who can give me the ip/hostname/programname.

then with this spid, I can myproc. Question: within myproc code, can I get the ip/hostname/programname with current spid? any function or system sp for this purpose?