OpenSchema perhaps?

[JasonGS]

Does anyone know how to retrieve a list of who is currently connected to a SQL Server 7 database???

[Clunietp]

Hi Jason

Login to the MASTER database, and SELECT * FROM SYSUSERS

Or you can peruse thru the SQL DMO object library to find it that way, but then you need the SQL server enterprise manager installed on your clients.....

Tom

[Clunietp]

My Bad!

Use SELECT * FROM SYSPROCESSES

SYSUSERS lists the users, not the active users

SYSPROCESSES will list all processes from the system and active users