Count of users connected to SQL Server 2000

[oricteropo]

is there any stored procedure or extended procedure which returns the number of connections currently open to SQL Server?
Thanks in advance,
Jeff

 

[JamesLean]

The system stored procs sp_who and sp_who2 both return details of current connections.

--James

 

[oricteropo]

Thanks,
That is what I was looking for. I was looking for a programmatic count. I found that if I just hit the system tables I get the results that I'm looking for.........

select d.name, count(spid)
from master.dbo.sysprocesses s, master.dbo.sysdatabases d
where s.dbid = d.dbid
group by d.name