0

This is not directly a programming question but I ask it anyway because it's related to debugging.

I wonder if it's possible to see exactly what SQL statements that are being executed within a procedure in Microsoft SQL Server Profiler?

For now I just see the procedures being called but due to complicated procedures causing a tricky bug somewhere I would like to see exactly what SQL statement being executed. So it would be nice if anyone has any tip on this.

jackJoe
  • 11,078
  • 8
  • 49
  • 64
Robert
  • 4,602
  • 4
  • 22
  • 33

1 Answers1

3

Yes this is possible.

Add SP:StmtStarting and/or SP:StmtCompleted to the events you are tracing.

Martin Smith
  • 438,706
  • 87
  • 741
  • 845