Method 1
DECLARE @HANDLE BINARY(20)
SELECT @HANDLE = SQL_HANDLE FROM SYSPROCESSES WHERE SPID = 52
SELECT * FROM ::FN_GET_SQL(@HANDLE)
Method 2
Select * from sys.sysprocesses
cross apply sys.dm_exec_sql_text (sql_handle)
Method 1
DECLARE @HANDLE BINARY(20)
SELECT @HANDLE = SQL_HANDLE FROM SYSPROCESSES WHERE SPID = 52
SELECT * FROM ::FN_GET_SQL(@HANDLE)
Method 2
Select * from sys.sysprocesses
cross apply sys.dm_exec_sql_text (sql_handle)