SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN
(
SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME='要查的数据库名'
(
SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME='要查的数据库名'
)
注意查看status字段.