sql server查询某个数据库的连接数

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME='DBName'
)

posted @ 2021-09-01 18:01  安相遇  阅读(110)  评论(0编辑  收藏  举报