Profiler and Prepared SQL from ODBC

#1

SQL profiler can report the event of SQL:StmtStarting and SQL:StmtCompleted. There is an event for Exec Prepared SQL.
This is the prepared version of SQL:StmtCompleted. I don't see the prepared event equivalent to SQL:StmtStarting. Is
there just not one or am i missing it?

danny

#2

It is an exec event not a completed or started so it only shows after it
execs. There is no other to the best of my knowledge.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Dan Holmes" <dan.holmes (AT) routematch (DOT) com> wrote

Quote:

SQL profiler can report the event of SQL:StmtStarting and
SQL:StmtCompleted. There is an event for Exec Prepared SQL. This is the
prepared version of SQL:StmtCompleted. I don't see the prepared event
equivalent to SQL:StmtStarting. Is there just not one or am i missing it?

danny

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Profiler and Prepared SQL from ODBC

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Profiler and Prepared SQL from ODBC - 03-04-2009 , 12:29 PM

Re: Profiler and Prepared SQL from ODBC - 03-04-2009 , 07:03 PM