how to get info - what user is exactly doing?

• Gabit Jan

  SSC Rookie

  Points: 45

  More actions

  April 30, 2007 at 5:47 am

  #75145

  how to get info - what user is exactly doing?
  what object is currently being selected, inserted or updated, etc

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 30, 2007 at 6:34 am

  #703255

  Use Profiler. Track the SPID of the user with sp_who and use that as a filter in Profiler.

• JeremyE

  SSCoach

  Points: 16201

  More actions

  May 1, 2007 at 11:42 am

  #703630

  You can use sp_who2 to find the SPID and DBCC INPUTBUFFER ().