1. Mark_newdba New Member

   Hi All,
   
   I need to view the sql statement of a running process. How do I do it from sql ? Thanks.

   Mark_newdba, Oct 1, 2003

   #2
2. Twan New Member

   dbcc inputbuffer( @spid )
   
   where @spid is the spid of the process you're interested in
   
   Cheers
   Twan

   Twan, Oct 2, 2003

   #2
3. satya Moderator

   @spid value can get from SP_WHO or SP_WHO2 from query analyzer.
   
   _________
   Satya SKJ
   Moderator
   SQL-Server-Performance.Com
   

   satya, Oct 2, 2003

   #2
4. Mark_newdba New Member

   Thanks for the info.

   Mark_newdba, Oct 2, 2003

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in