DatabaseDdlTriggerEventSet Members

  • Article

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

The following tables list the members exposed by the DatabaseDdlTriggerEventSet type.

Public Constructors

  Name Description
DatabaseDdlTriggerEventSet Overloaded. Initializes a new instance of the DatabaseDdlTriggerEventSet class.

Top

Public Properties

(see also Protected Properties )

  Name Description
ms219350.pubproperty(en-US,SQL.90).gif AlterApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterAuthorizationDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization database is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered.
ms219350.pubproperty(en-US,SQL.90).gif AlterXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered.
ms219350.pubproperty(en-US,SQL.90).gif CreateApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created.
ms219350.pubproperty(en-US,SQL.90).gif CreatePartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created.
ms219350.pubproperty(en-US,SQL.90).gif CreatePartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateXmlIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created.
ms219350.pubproperty(en-US,SQL.90).gif CreateXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created.
ms219350.pubproperty(en-US,SQL.90).gif DdlApplicationRoleEvents Gets or sets a Boolean property value that specifies whether DDL application role events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlAssemblyEvents Gets or sets a Boolean property value that specifies whether DDL assembly events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlAuthorizationDatabaseEvents Gets or sets a Boolean property value that specifies whether DDL authorization database events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlContractEvents Gets or sets a Boolean property value that specifies whether DDL contract events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlDatabaseLevelEvents Gets or sets a Boolean property value that specifies whether DDL database level events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlDatabaseSecurityEvents Gets or sets a Boolean property value that specifies whether DDL database security events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlEventNotificationEvents Gets or sets a Boolean property value that specifies whether DDL event notification events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlFunctionEvents Gets or sets a Boolean property value that specifies whether DDL user-defined function events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlGdrDatabaseEvents Gets or sets a Boolean property value that specifies whether DDL grant, deny, or revoke database events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlIndexEvents Gets or sets a Boolean property value that specifies whether DDL index events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlMessageTypeEvents Gets or sets a Boolean property value that specifies whether DDL message type events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlPartitionEvents Gets or sets a Boolean property value that specifies whether DDL partition events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlPartitionFunctionEvents Gets or sets a Boolean property value that specifies whether DDL partition function events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlPartitionSchemeEvents Gets or sets a Boolean property value that specifies whether DDL partition scheme events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlProcedureEvents Gets or sets a Boolean property value that specifies whether DDL stored procedure events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlQueueEvents Gets or sets a Boolean property value that specifies whether DDL Service Broker queue events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlRemoteServiceBindingEvents Gets or sets a Boolean property value that specifies whether DDL remote service binding events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlRoleEvents Gets or sets a Boolean property value that specifies whether DDL database role events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlRouteEvents Gets or sets a Boolean property value that specifies whether DDL Service Broker route events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlSchemaEvents Gets or sets a Boolean property value that specifies whether DDL schema events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlServiceEvents Gets or sets a Boolean property value that specifies whether DDL Service Broker service events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlSsbEvents Gets or sets a Boolean property value that specifies whether DDL Service Broker events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlStatisticsEvents Gets or sets a Boolean property value that specifies whether DDL statistics counter events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlSynonymEvents Gets or sets a Boolean property value that specifies whether DDL synonym events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlTableEvents Gets or sets a Boolean property value that specifies whether DDL table events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlTableViewEvents Gets or sets a Boolean property value that specifies whether DDL table view events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlTriggerEvents Gets or sets a Boolean property value that specifies whether DDL trigger events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlTypeEvents Gets or sets a Boolean property value that specifies whether DDL type events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlUserEvents Gets or sets a Boolean property value that specifies whether DDL database user events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlViewEvents Gets or sets a Boolean property value that specifies whether DDL view events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DdlXmlSchemaCollectionEvents Gets or sets a Boolean property value that specifies whether DDL XML schema collection events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif DenyDatabase Gets or sets a Boolean property value that specifies whether events are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif Dirty Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when data stored in the cache needs refreshing is encountered.
ms219350.pubproperty(en-US,SQL.90).gif DropApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Service Broker queue is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped.
ms219350.pubproperty(en-US,SQL.90).gif DropXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped.
ms219350.pubproperty(en-US,SQL.90).gif GrantDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
ms219350.pubproperty(en-US,SQL.90).gif NumberOfElements Overridden. Gets the number of events that are included in the event set.
ms219350.pubproperty(en-US,SQL.90).gif RevokeDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is revoked from the database.
ms219350.pubproperty(en-US,SQL.90).gif UpdateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when statistics are updated.

Top

Protected Properties

  Name Description
ms219350.protproperty(en-US,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219350.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a set of database DDL trigger events after adding a new event to the event set.
ms219350.pubmethod(en-US,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms219350.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219350.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219350.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219350.pubmethod(en-US,SQL.90).gifms219350.static(en-US,SQL.90).gif op_Addition Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
ms219350.pubmethod(en-US,SQL.90).gifms219350.static(en-US,SQL.90).gif op_Subtraction Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
ms219350.pubmethod(en-US,SQL.90).gifms219350.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219350.pubmethod(en-US,SQL.90).gif Remove Removes an event from the event set.
ms219350.pubmethod(en-US,SQL.90).gifms219350.static(en-US,SQL.90).gif Subtract Returns a set of database DDL trigger events after removing an event from the event specified set.
ms219350.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a string that represents the DatabaseDdlTriggerEventSet object.

Top

Protected Methods

  Name Description
ms219350.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219350.protmethod(en-US,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms219350.protmethod(en-US,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms219350.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219350.protmethod(en-US,SQL.90).gif SetValue  (inherited from EventSetBase )

Top

See Also

Reference

DatabaseDdlTriggerEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events