Jaa


TSQL Event Category

The TSQL event category contains general TSQL events.

In This Section

Topic 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 2005 executes an XQuery expression.

See Also

Other Resources

Monitoring Events
Transact-SQL Reference (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance