TSQL Script to fetch the code that is executed by an SPID

Below is the TSQL Script to fetch the code that is executed by an SPID

[sql]
DECLARE @sql_handle AS VARBINARY (1000)

SELECT @sql_handle = SQL_HANDLE
FROM sys.sysprocesses WITH (NOLOCK)
WHERE spid = 56; –To Do: Update with SPID OF the Process

SELECT *
FROM sys.dm_exec_sql_text (@sql_handle)
[/sql]

Leave a Reply

Your email address will not be published. Required fields are marked *