select * from sysprocesses where dbid in (select dbid from sysdatabases where name='fenshiyuyueZS')

SELECT name ,count(*) FROM (
SELECT b.name,a.* FROM [Master].[dbo].[SYSPROCESSES] a
INNER JOIN [Master].[dbo].[SYSDATABASES] b
ON a.dbid=b.dbid
)t
GROUP BY t.name