profiler or extended event does not show parameter value

Surendra Adhikari 211 Reputation points
2023-05-04T05:33:16.5633333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,102 questions
{count} votes

2 answers

Sort by: Most helpful
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-05-04T05:50:05.1633333+00:00

    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.

    0 comments No comments

  2. kedar giri 20 Reputation points
    2023-05-04T10:21:51.24+00:00
    0 comments No comments