Unanswered: Problem in Tracing DML using SQLPROFILER
i am using profiler to trace DMLs on my database.
i've set event classes RPC:COMPLETED and SQL:BatchCompleted.
When i run asp code using ADDNEW command; the profiler doesn't trace the Insert command. However the values get inserted into the database.
How can i square this?
What's the best way to log only DMLs within a database using profiler to remove overhead of tracing Select statements.