Yes. If you run sp_lock, you'll see that each connection has a SHARED DATABASE lock on the database that the connection is within the context of. You'll have to query the master..syslockinfo table and only pull those locks.
-Mike
>Hi All.
>Is there a way to obtain the list of users who currently USE a certain database?
>We run MS SQL 2000.
>Thanks