sa_conn_info system procedure

Function

Reports connection property information.

Syntax

sa_conn_info ( [ connection-id ] )

Permissions

None.

Description

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.

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.

Example

sa_conn_info
569851433,'','DBA',0,'','0.0',1,
'CURSOR_OPEN','local','',6821,0,0,1008