Sample Header Ad - 728x90

SQL profiler not showing incoming parameters of store procedure

3 votes
1 answer
2258 views
**My Task** When user updates some values on the front end UI of an application, I want to know which SQL table/fields are updated, which SQL statements were executed, etc. **My method** Using SQL profiler, I updated some value from the applications user interface. then try to track the SQL statements executed. In Events Selection Tab, I selected all RPC & TSQL. **Problem** SQL Profiler does not show the value of incoming parameter, showing e.g. exec [sys].sp_describe_undeclared_parameters N'SELECT FIELD_NAME FROM EXTRA_FIELDS WHERE TABLE_NAME = @P1 AND EDITABLE = ''N'' ORDER BY CONTROL_NO, SEQNO' Is there anyway I can get the @P1 value? **See screenshot** enter image description here
Asked by ppau2004 (141 rep)
Jul 4, 2021, 10:47 AM
Last activity: Jun 11, 2023, 05:07 AM