pssinfo

Returns information from the process status structure, with an option that retrieves the transaction isolation level of any spid.

pssinfo ( <spid | 0>, 'pss field>')

select pssinfo (@@spid, 'ipaddr')
--------------
10.21.37.21
(1 row affected)