What Statement is being executed

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  November 1, 2002 at 9:47 pm

  #58139

  How can i know what statement is associated with what spid in Query Analyzer. I mean that if you look in the current activity in Enterprise Manager, and double click on any Process Id it gives the statement being executed. How can i find the same With Query Analyzer? I thought context_info column in sysprocesses table stores the information but it didnot work for me. Any help would be appreciated.

• joachim.verhagen

  Hall of Fame

  Points: 3560

  More actions

  November 2, 2002 at 3:09 am

  #440127

  I was looking for this myself this week.

  The following does it:

  DBCC INPUTBUFFER (spid)

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  November 4, 2002 at 2:14 pm

  #440275

  Thanks Joachim. It works great. Can you let me know if you come to know a different way also?

  Thanks once again for your help.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 4, 2002 at 2:24 pm

  #440279

  Try Profiler.