So, I got this:
A simple trace with
But, how can I know the query that has the problem listed here?
I don't think
DBCC INPUTBUFFER(X) is appropriated to this.
Well, I'm using:
- RPC: COMPLETED
- RPC: STARTING
- SP: COMPLETED
And I can see this now:
is there a better approach for this?
I could find the query, because it was the only statement using TOP.I think it was luck.