SQL Server: Listing sessions in 2000

SELECT DB_NAME(dbid) as 'Database Name', COUNT(dbid) as 'Total Connections' FROM master.dbo.sysprocesses WITH (nolock) WHERE dbid > 0 GROUP BY dbid SELECT DB_NAME(dbid) as 'Database Name', a.* FROM master.dbo.sysprocesses a WITH (nolock) WHERE dbid > 0