1

I am trying to capture all statements/SPs and RPCs (either they finish or fail) on a SQL 2005 server using SQL trace. Are the following events enough?

Exceptions
Stored Procedure
RPC:Completed
RPC:Starting
SP:Recompile
TSQL
SQL:StmtCompleted
SQL:StmtStarting

thanks!

1
  • You may also want to capture the SQL:BatchStarting and SQL:BatchCompleted events. Sep 13 '11 at 0:12
4

Just use a trace template. Click File, New Trace, and choose the Replay template. That'll get you everything that happens.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.