SQL Server连接数的查询

select * from sysprocesses
where dbid in(
SELECT dbid FROM master.dbo.sysdatabases
WHERE NAME='DB_CEMS'
)