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**

Asked by ppau2004
(141 rep)
Jul 4, 2021, 10:47 AM
Last activity: Jun 11, 2023, 05:07 AM
Last activity: Jun 11, 2023, 05:07 AM