查询Spid 下对应Sql语句

select er.session_id
, CAST(csql.text AS varchar(255)) AS CallingSQL
from master.sys.dm_exec_requests er 
WITH (NOLOCK)
       CROSS APPLY MASTER.sys.fn_get_sql (er.sql_handle) csql
where er.session_id =51

session_id即为 Spid

转载于:https://www.cnblogs.com/weiqt/articles/4318458.html