ServerDdlTriggerEventSet Class

The ServerDdlTriggerEventSet object represents a set of Microsoft SQL Server server data definition language (DDL) trigger events.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)

Syntax

'Declaration
Public NotInheritable Class ServerDdlTriggerEventSet
    Inherits EventSetBase
public sealed class ServerDdlTriggerEventSet : EventSetBase
public ref class ServerDdlTriggerEventSet sealed : public EventSetBase
public final class ServerDdlTriggerEventSet extends EventSetBase
public final class ServerDdlTriggerEventSet extends EventSetBase

Remarks

Updated text:

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The ServerDdlTriggerEventSet object contains a property for each event to which the server DDL trigger responds

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet

Example

How to: Register Event Handlers and Subscribe to Event Handling in Visual Basic .NET

Thread Safety

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

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ServerDdlTriggerEventSet Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events
Event Groups for Use with DDL Triggers

Change History

Release

History

New content:
  • Added Add method overload to the ServerDdlTriggerEventSet class.

  • Added Subtract method to the ServerDdlTriggerEventSet class.

Content changed:
  • Descriptions of properties (events) have been updated.