Robert
Reputation: 4830
Se SQL statetement beeing run within a procedure with SQL Server Profiler
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.
Upvotes: 0
Views: 51
Answers (1)
Martin Smith
Reputation: 453243
Yes this is possible.
Add SP:StmtStarting and/or SP:StmtCompleted to the events you are tracing.
Upvotes: 3
Related Questions
- SQL Server profiler shows stored procedure being called but is not actually executed
- Trying to get procedure name from SQL Server Profiler, 'sp_reset_connection' shows instead
- stored procedure execution gives different results in SSIS Vs. SSMS
- execution of stored procedure in sql profiler
- SQL Server Profiler: Get stored procedure name
- SQL Profiler displaying stored procedure that doesn't exist
- Stored procedure output parameters in SQL Server Profiler
- stored procedure wrong in profiler
- See running procedure in SQL server Profiler
- Sql Profiler Scan Started to execute a stored procedure