SQL Server获取数据库的当前连接状态

SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID]=(SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE [NAME]='数据库名')

原文地址:https://www.cnblogs.com/TanSea/p/Connection-State.html