I noticed that if I have a service running multiple databases sa_conn_info()
will show me the users connected to all the databases (not just the one I am
logged into).

Is there a way to list the connections only in the database that I am
connected to?

I am running 9.0.2.3320

As a side note it seems like a a security issue that I can see who is logged
into a database that I have not signed into. Is that a problem?

Thank you.

select * from sa_conn_info()
where dbnumber = connection_property( 'dbnumber');

Paul Horan[TeamSybase]

"David DeRam" <ns_xxxdderam (AT) progeny2000ns_xxx (DOT) com> wrote