--1、查进程
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
order by request_session_id
--2、查sql
select er.session_id, CAST(csql.text AS varchar(2000)) AS CallingSQL
from master.sys.dm_exec_requests er WITH (NOLOCK)
CROSS APPLY fn_get_sql (er.sql_handle) csql
where er.session_id =52
---------
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。