DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52
SELECT * FROM ::fn_get_sql(@Handle)
SELECT * FROM sys.sysprocesses s CROSS APPLY fn_get_sql(sql_handle)
How to use sysprocesses – ::fn_get_sql
Uncategorized
0 Comments.