select count(*) from master.dbo.sysprocesses where dbid=db_id('数据库名称')
select
count(*)
from master..sysprocesses
where hostname<>'' and dbid=db_id('数据库名称')
转载于:https://www.cnblogs.com/zhangpengshou/archive/2008/03/10/1098227.html