To view Query using SPID

Query:

DECLARE @sql_handle varbinary(64)
DECLARE @stmt_start int
DECLARE @stmt_end int

DECLARE @spid_i INT
set @spid_i = 56 /*Your Spid to check*/

SELECT @sql_handle = sql_handle,
@stmt_start = stmt_start,
@stmt_end = stmt_end
from sys.sysprocesses with (nolock)
where spid = @spid_i

select text as ‘Full Query’,
case when @stmt_start > 0 then
case when @stmt_end > @stmt_start then
substring(text, @stmt_start/2, (@stmt_end/2)-(@stmt_start/2))
else
substring(text, @stmt_start/2, len(text))
end
else
null
end as ‘Current Command’, @stmt_start, @stmt_end
from sys.dm_exec_sql_text(@sql_handle)