HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL Profiler - Insert values?

Submitted by: @import:stackexchange-dba··
0
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:

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 SQL:StmtStarting and SP:StmtStarting along with SQL:BatchStarting or SP:Starting

Better to use server-side trace rather than using GUI.

Context

StackExchange Database Administrators Q#59145, answer score: 3

Revisions (0)

No revisions yet.