If by "last Activity" you mean what did each connection do, when did it do it, then the easy answer is to use
to get this information about connection connid See this documentation page for a full list of information about each connection that can be obtained by using connection_property() or connection_extended_property() You can also get the connection activity information by using the sa_conn_activity() procedure. FWIW: You can get the full list of properties for a connection (or all connections) by using the sa_conn_properties() procedure. HTH Exactly how is connection_extended_property called without the second argument but with the third argument? AFAIK in this context connection_property is the function of choice.
(16 Nov '15, 14:35)
Breck Carter
Replies hidden
One doesn't try to omit a parameter ;-). I corrected my answer to use connection_property()
(16 Nov '15, 14:40)
Mark Culp
|