select db_name(dbid) as [Database Name], count(dbid) as [No Of Connections], loginame as [Login Name] from sys.sysprocesses where dbid > 0 group by dbid, loginame登录后复制