T-SQL Event Category

The

event category contains general Transact-SQL events.

Description

Exec Prepared SQL Event

Class

Indicates that the SqlClient, ODBC, OLE DB, or DB-Library has executed a

prepared Transact-SQL statement or statements.

Prepare SQL Event Class

Indicates that SqlClient, ODBC, OLE DB, or DB-Library has prepared a

Transact-SQL statement or statements for use.

SQL:BatchCompleted Event

Class

Indicates that the Transact-SQL batch has completed.

SQL:BatchStarting Event

Class

Indicates that the Transact-SQL batch is starting.

SQL:StmtCompleted Event

Class

Indicates that a Transact-SQL statement has completed.

SQL:StmtRecompile Event

Class

Indicates statement-level recompilations caused by all types of batches:

stored procedures, triggers, ad hoc batches, and queries.

SQL:StmtStarting Event

Class

Indicates that a Transact-SQL statement is starting.

Unprepare SQL Event Class

Indicates that the SqlClient, ODBC, OLE DB, or DB-Library has deleted a

prepared Transact-SQL statement or statements.

XQuery Static Type Event

Class

Occurs when SQL Server executes an XQuery expression.

Transact-SQL Reference (Database Engine)

ﾉ

Expand table