how to know how many users are connected to a particular database in sqlserver2000

Question

how to know how many users are connected to a particular database

Answer 1

You can use the stored procedure sp_who2

Answer 2

For a simply query, you can use this on SQL 2000 to SQL 2008 (there is no 1:1 replacement for sysprocesses in SQL 2005)

SELECT
    COUNT(*)
FROM
    MASTER..sysprocesses
WHERE
    dbid = DB_ID('MyDBName')

Answer 3

SELECT COUNT(DISTINCT spid)
FROM master.dbo.sysprocesses
WHERE spid >= 50
AND dbid = DB_ID('MyDBName')