Discussion in 'Performance Tuning for DBAs' started by Mark_newdba, Oct 1, 2003.
I need to view the sql statement of a running process. How do I do it from sql ? Thanks.
dbcc inputbuffer( @spid )
where @spid is the spid of the process you're interested in
@spid value can get from SP_WHO or SP_WHO2 from query analyzer.
Thanks for the info.
Separate names with a comma.