select count(*) from master.dbo.sysprocesses where dbid=db_id('数据库名称') select count(*) from master..sysprocesses where hostname<>'' and dbid=db_id('数据库名称')