摘要：
select er.session_id, CAST(csql.text AS varchar(255)) AS CallingSQLfrom master.sys.dm_exec_requests er WITH (NOLOCK) CROSS APPLY MASTER.sys.fn_g... 阅读全文
摘要：
SELECT * FROM master..sysprocesses WHERE dbid=DB_ID('db')db换成对应的数据库名即可断开所有活动连接的存在过程方法ALTER PROC [dbo].[P_KillConnections] @dbname VARCHAR(200)AS D... 阅读全文