Breaking News: Grepper is joining You.com. Read the official announcement!

mssql get running queries by spid

Lucifer answered on March 5, 2022 Popularity 1/10 Helpfulness 1/10

answer mssql get running queries by spid

mssql get running queries by spid

Comment

declare
    @spid int
,   @stmt_start int
,   @stmt_end int
,   @sql_handle binary(20)

set @spid = XXX -- Fill this in

select  top 1
    @sql_handle = sql_handle
,   @stmt_start = case stmt_start when 0 then 0 else stmt_start / 2 end
,   @stmt_end = case stmt_end when -1 then -1 else stmt_end / 2 end
from    sys.sysprocesses
where   spid = @spid
order by ecid

SELECT
    SUBSTRING(  text,
            COALESCE(NULLIF(@stmt_start, 0), 1),
            CASE @stmt_end
                WHEN -1
                    THEN DATALENGTH(text)
                ELSE
                    (@stmt_end - @stmt_start)
                END
        )
FROM ::fn_get_sql(@sql_handle)

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: get spid sql

Link to this answer
Share Copy Link