In a trace how do I capture parameter values for event class 44 SP:StmtStarting?

Question

In my trace I see stored procedures calls in my text data like this:

EXEC SomeStoredProcedure, @Param1, @Param2

How can I capture the values of those parameters?

This is for event class

score 2 · Accepted Answer · edited May 23 '17 at 09:59

2

Are these SP calls within an SP?

The Stmt events are statements within the procedure.

Look at the RPC:Completed: SQL Server Profile - View Parameter Values? or 43:SP:Completed

edited May 23 '17 at 09:59

Community

answered Feb 15 '12 at 16:09

Cade Roux

1 Answers1