TRC_ALL_EVENTS

  • Article

This event type or event group can be specified when you create Event Notifications to monitor and respond to activity in the database or server instance. Event notifications can be created directly in the SQL Server Database Engine or by using the WMI Provider for Server Events. Some events can also be used when you create DDL triggers. For more information, see Designing DDL Triggers.

Children: TRC_USER_CONFIGURABLE, TRC_OBJECTS, TRC_ERRORS_AND_WARNINGS, TRC_DEPRECATION, TRC_QUERY_NOTIFICATIONS, TRC_DATABASE, TRC_OLEDB, TRC_STORED_PROCEDURES, TRC_TSQL, TRC_FULL_TEXT, TRC_SECURITY_AUDIT, TRC_SERVER, TRC_PERFORMANCE, TRC_CLR, TRC_LOCKS

Properties

Inherited from Parents

Name CIM Type

SQLInstance

String

PostTime

DateTime

SPID

Sint32

ComputerName

String

Event Properties

Name CIM Type

SessionLoginName

String

EventSequence

Sint32

Change History

Release History

14 April 2006
Changed content:
  • Removed events that are not valid from the list of children events.
  • Removed ALL_EVENTS as a valid parent event.