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
sp_describe_undeclared_parameters
the whole point is to find undeclared parameters