var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: get the spid to get ip
In order to make an specific audit for my data of my ASE 12.5.3 database,
I need to get the ip of the user who execute my storage procedure.
I already use host_name() but it doesn't work, sometime it replies nothing.
I have a limited access i'm not dbo but i have access to master..sysprocesses.
Did someone can help to find a way to get the ip of the user which execute my storage procedure?
select ipaddr from master..sysprocesses where spid = @@spid
will work for ASE 12.x and later.
thanks a lot.
IT WORKS !!!