profiler or extended event does not show parameter value

Question

while tracing sp execution statement in profiler or extended event, the actual parameter values are not shown but only parameters name are shown.

Answer 1

Hi @Surendra Adhikari

You can see if these two threads can help you.

https://stackoverflow.com/questions/53343184/sql-server-profiler-trace-not-showing-parameter-values

https://stackoverflow.com/questions/1952830/how-do-i-get-parameter-values-for-sql-server-query-in-sql-server-profiler/1952890#1952890

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Surendra Adhikari dai

may be this will be helpfull

https://www.scarydba.com/2018/09/24/extended-events-and-stored-procedure-parameter-values/

Best Regards

kedar giri