Cursors Data Columns

Administering SQL Server

Administering SQL Server

Cursors Data Columns

The following table lists the data columns for each event class in the Cursors event category.

Event class Data column Description
CursorClose Event Class Type of event recorded = 78.
  Handle Handle of the cursor.
CursorExecute Event Class

Handle

Integer Data

Type of event recorded = 74.

Handle of the cursor.

Cursor type. Values are:

1  = Keyset
2  = Dynamic
4  = Forward only
8  = Static
16 = Fast forward

CursorImplicitConversion Event Class Type of event recorded = 76.
  Handle Handle of the cursor.
  Integer Data Requested cursor type. Values are:

1  = Keyset
2  = Dynamic
4  = Forward only
8  = Static
16 = Fast forward

  Binary Data Resulting cursor type. Values are:

1  = Keyset
2  = Dynamic
4  = Forward only
8  = Static
16 = Fast forward

CursorOpen Event Class

Handle

Integer Data

Type of event recorded = 53.

Handle of the cursor.

Cursor type. Values are:

1  = Keyset
2  = Dynamic
4  = Forward only
8  = Static
16 = Fast forward

CursorPrepare Event Class Type of event recorded = 70.
  Handle Handle of the prepared cursor.
CursorRecompile Event Class

Handle

Type of event recorded = 75.

Handle of the cursor that had to be recompiled.

CursorUnprepare Event Class

Event Sub Class

Type of event recorded = 77.

Handle of the cursor created by CursorPrepare.


See Also

Cursors

Cursors Event Classes

Cursors Event Category