Does anyone know how to retrieve a list of who is currently connected to a SQL Server 7 database???
Printable View
Does anyone know how to retrieve a list of who is currently connected to a SQL Server 7 database???
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
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