0

When I use SQL server profiler to trace the SQL statement flow using SP:StmtCompleted,

I can only read the variables as @P0, @P1, etc. like:

insert into CaseFollowup (createDate, duration) values (@P0, @P1)

Can I read the actual value of @P0, @P1?

Thanks for your help!

1 Answer 1

1

Use rpc_completed to get parameter values. Also, use extended events instead of profiler if you're on SQL 2012 or newer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.