Reports connection property information.
sa_conn_info ( [ connection-id ] )
None.
Returns a result set consisting of the following connection properties for the supplied connection. If no connection-id is supplied, information for all current connections to databases on the server is returned.
Number
Name
Userid
DBNumber
LastReqTime
ProcessTime
Port
ReqType
CommLink
NodeAddr
LastIdle
CurrTaskSwitch
BlockedOn
UncommitOp
In a deadlock situation, the BlockedOn value returned by this procedure allows you to check which users are blocked, and who they are blocked on.
sa_conn_info
569851433,'','DBA',0,'','0.0',1, 'CURSOR_OPEN','local','',6821,0,0,1008
