Reports connection property information.
sa_conn_info ( [ connection-id ] )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
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
ReqType
CommLink
NodeAddr
ClientPort
ServerPort
BlockedOn
LockRowID
LockIndexID
LockTable
UncommitOps
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
