Export (0) Print
Expand All

Errors and Warnings Data Columns

SQL Server 2000

Errors and Warnings Data Columns

These are the data columns for each event class in the Errors and Warnings event category.

Event class Data column Description
Attention Event Class Type of event recorded = 16.
ErrorLog Event Class Type of event recorded = 22.
  Error Error number.
  Severity Severity of the error generated.
  Text Data Text of the error message.
EventLog Event Class Type of event recorded = 21.
  Binary Data Binary value dependent on the event class captured in the trace.
  Error Error number.
  Severity Error severity.
  Text Data Text of the error message, if available.
Exception Event Class Type of event recorded = 33.
  Error Error number.
  State Server state.
  Severity Error severity.
Execution Warnings Event Class Type of event recorded = 67.
  Event Sub Class The type of execution warning. Can have these values:

1 = Query wait. The query must wait for resources (for example, memory) before it can execute.
2 = Query time-out. The query timed out while waiting for required resources to execute.

  Error Error number.
Hash Warning Event Class Type of event recorded = 55.
  Event Sub Class Type of hash operation. Can have these values:

0 = Hash recursion.
1 = Hash bail.

  Integer Data Recursion level (hash recursion only).
  Object ID Node ID of the root of the hash involved in the repartition.
Missing Column Statistics Event Class Type of event recorded = 79.
  Text Data List of the columns with missing statistics.
Missing Join Predicate Event Class Type of event recorded = 80.
OLEDB Errors Event Class Type of event recorded = 61.
  Text Data Error message from OLE DB.
Sort Warnings Event Class Type of event recorded = 69.
  Event Sub Class Type of sort warning. Can have these values:

1 = Single pass. When the sort table was written to disk, only a single additional pass over the data to be sorted was required to obtain sorted output.
2 = Multiple pass. When the sort table was written to disk, multiple passes over the data were required to obtain sorted output.


See Also

Error Messages

Monitoring the Error Logs

Errors and Warnings Event Classes

Errors and Warnings Event Category

Show:
© 2014 Microsoft