patternMinor
SQL Profiler - Insert values?
Viewed 0 times
sqlvaluesinsertprofiler
Problem
I setup an SQL profiler to run, but I am not seeing any values for updates/inserts. Is there a way to see them?
All I see is stuff like this:
I would love to actually see the values being inserted rather than just a generic variable, but can't seem to figure it out?
All I see is stuff like this:
insert into some_tbl(id, col1, col2, col3) values ( @P0 , @P1 , @P2 )I would love to actually see the values being inserted rather than just a generic variable, but can't seem to figure it out?
Solution
You can select
Better to use server-side trace rather than using GUI.
SQL:StmtStarting and SP:StmtStarting along with SQL:BatchStarting or SP:StartingBetter to use server-side trace rather than using GUI.
Context
StackExchange Database Administrators Q#59145, answer score: 3
Revisions (0)
No revisions yet.