I am running SQL Profiler looking for queries taking longer than 1 second. The Trace file contains many items of the form:
Event Class: RPC Completed
Text Data: exec sp_execute ####
where "####" is a number that seems to increas as the trace runs - the numbers are two digits at the beginning, and into the thousands at the end.
How do I find out what the SQL was that was executed?
I tried capturing "prepare" events, but those are cryptic as well - they tell me that something was prepared, but not what that something was.