해당 SPID가 수행하고있는 쿼리보기

DECLARE @SQL_HANDLE VARbINARY(2000)
Declare @spid                smallint

-- Setting SP_ID
set @spid = 65

select  @sql_handle = a.sql_handle
from master.dbo.sysprocesses a
left join sys.dm_exec_requests b
on a.spid = b.session_id
where a.spid = @spid
    and a.spid = @spid

select * from  sys.dm_exec_sql_text(@SQL_HANDLE)