Get SQLQuery From SP ID

--DBCC INPUTBUFFER(83)

DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 224
SELECT TEXT FROM ::fn_get_sql(@sqltext)

No comments:

Post a Comment