TriggerEvents Class

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

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.TriggerEvents

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Class TriggerEvents
'Usage
Dim instance As TriggerEvents
public class TriggerEvents
public ref class TriggerEvents
type TriggerEvents =  class end
public class TriggerEvents

The TriggerEvents type exposes the following members.

Methods

  Name Description
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetEventSelection Returns the currently selected event notifications.
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method StartEvents Starts receiving events.
Public method StopEvents Stops receiving events.
Public method SubscribeToEvents(ObjectEventSet) Specifies the trigger events to receive.
Public method SubscribeToEvents(ObjectEventSet, ServerEventHandler) Specifies the trigger events to receive and the event handler that handles the events.
Public method ToString (Inherited from Object.)
Public method UnsubscribeAllEvents Clears all event settings, and removes all event handlers.
Public method UnsubscribeFromEvents Clears the specified event settings, and removes all event handlers.

Top

Events

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

Top

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.

Examples

Handling SMO Events

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace