sp_who

[sujosh]

I want to get the connections in a particular database. sp_who does it for all db in the server. Is there a sp which gives me active connections for a specific db?



Thanks
JD

 

[fluteplr]

This works in sql 2000 I am not sure about prior versions.

select distinct loginame from master.dbo.sysprocesses
where dbid = db_id('mydatabasename')

I know loginame looks like a type (sb loginname) but that is the way it is named in sysprocesses.