Cursors Event Classes

Administering SQL Server

Administering SQL Server

Cursors Event Classes

The following table describes the Cursors event classes in the Cursors event category.

Event class Description
CursorClose A cursor previously opened on a Transact-SQL statement by ODBC, OLE DB, or DB-Library is closed.
CursorExecute A cursor previously prepared on a Transact-SQL statement by ODBC, OLE DB, or DB-Library is executed. For more information, see How to prepare and execute a statement (ODBC).
CursorImplicitConversion A cursor on a Transact-SQL statement is converted by Microsoft® SQL Server™ from one type to another.

Triggered for ANSI and non-ANSI cursors.

CursorOpen A cursor is opened on a Transact-SQL statement by ODBC, OLE DB, or DB-Library.
CursorPrepare A cursor on a Transact-SQL statement is prepared for use by ODBC, OLE DB, or DB-Library. For more information, see How to prepare and execute a statement (ODBC).
CursorRecompile A cursor opened on a Transact-SQL statement by ODBC or DB-Library has been recompiled either directly or indirectly due to a schema change.

Triggered for ANSI and non-ANSI cursors.

CursorUnprepare A prepared cursor on a Transact-SQL statement is deleted by ODBC, OLE DB, or DB-Library.

See Also

Cursors Event Category

Cursors Data Columns