SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN (SELECT [DBID]FROM [Master].[dbo].[SYSDATABASES] WHERE NAME=’数据库名’)
或
分离数据库,也可以查看
SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN (SELECT [DBID]FROM [Master].[dbo].[SYSDATABASES] WHERE NAME=’数据库名’)
或
分离数据库,也可以查看
转载于:https://www.cnblogs.com/elysian/p/6230184.html