List Logged in Users

[DanAuber]

From an SQL Anywhere SQL prompt, what query can I type to list logged in users...? - What table is written to when users log in ?

Thanks for any help

dan

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[qyllr]

hello,

try sp_who...

when users login you can find the entry in the sysprocesses system table... this is the table where the sp_who system stored procedure gets the information...

hth,
q.

 

[Starg]

or if your using the version of Adaptive Server Anywhere that comes with Sybase IQ, don't use sp_who buy sa_conn_info

 

[DanAuber]

Thanks guys but no dice. The sp_who comes back as a not recognised command and there are no entries in the sysprocesses table despite the fact that there ARE people logged in.

When I go into the SYBASE control feature and click on the logged in users folder, what table is that querying in the DB ??



Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/