TriggerEvents TriggerEvents TriggerEvents Class

Definition

The TriggerEvents object represents the settings that are required for SQL Server trigger event notification.

public ref class TriggerEvents
public class TriggerEvents
Public Class TriggerEvents
Inheritance
TriggerEventsTriggerEventsTriggerEvents

Examples

Handling SMO Events

Remarks

The TriggerEvents class is accessed through Events property and cannot be created as a stand-alone object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Methods

GetEventSelection() GetEventSelection() GetEventSelection()

Returns the currently selected event notifications.

StartEvents() StartEvents() StartEvents()

Starts receiving events.

StopEvents() StopEvents() StopEvents()

Stops receiving events.

SubscribeToEvents(ObjectEventSet) SubscribeToEvents(ObjectEventSet) SubscribeToEvents(ObjectEventSet)

Specifies the trigger events to receive.

SubscribeToEvents(ObjectEventSet, ServerEventHandler) SubscribeToEvents(ObjectEventSet, ServerEventHandler) SubscribeToEvents(ObjectEventSet, ServerEventHandler)

Specifies the trigger events to receive and the event handler that handles the events.

UnsubscribeAllEvents() UnsubscribeAllEvents() UnsubscribeAllEvents()

Clears all event settings, and removes all event handlers.

UnsubscribeFromEvents(ObjectEventSet) UnsubscribeFromEvents(ObjectEventSet) UnsubscribeFromEvents(ObjectEventSet)

Clears the specified event settings, and removes all event handlers.

Events

ServerEvent ServerEvent ServerEvent

Specifies the event raised when an event occurs in Trigger object and the user has subscribed to the events from that object instance.

Applies to