3中查询数据库连接数

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID]
IN
(
  SELECT
   [DBID]
  FROM
   [Master].[dbo].[SYSDATABASES]
  WHERE
   NAME='SWT_MicroManage'
)
go
SELECT COUNT(*) AS CONNECTIONS FROM master..sysprocesses
go

SP_WHO 'swt'
go

分类:  SqlServer

本文转自快乐就好博客园博客，原文链接：http://www.cnblogs.com/happyday56/p/3831265.html，如需转载请自行联系原作者