DECLARE @Handle binary(20), @spid int
set @spid = 52

SELECT @Handle = sql_handle
FROM master.dbo.sysprocesses WHERE spid = @spid

SELECT * FROM ::fn_get_sql(@Handle)

-- ou
dbcc inputbuffer( @spid )