Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DatabaseDdlTriggerEventSet Class

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

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
public sealed class DatabaseDdlTriggerEventSet : EventSetBase

The DatabaseDdlTriggerEventSet type exposes the following members.

  NameDescription
Public methodDatabaseDdlTriggerEventSet()Initializes a new instance of the DatabaseDdlTriggerEventSet class.
Public methodDatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent)Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
Public methodDatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent[])Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
Public methodDatabaseDdlTriggerEventSet(DatabaseDdlTriggerEventSet)Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
Top
  NameDescription
Public propertyAddRoleMemberGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAddSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAddSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterApplicationRoleGets 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.
Public propertyAlterAssemblyGets 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.
Public propertyAlterAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterAuthorizationDatabaseGets 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.
Public propertyAlterBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterCertificateGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
Public propertyAlterDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is altered.
Public propertyAlterFunctionGets 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.
Public propertyAlterIndexGets 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.
Public propertyAlterMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterMessageTypeGets 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.
Public propertyAlterPartitionFunctionGets 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.
Public propertyAlterPartitionSchemeGets 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.
Public propertyAlterPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterProcedureGets 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.
Public propertyAlterQueueGets 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.
Public propertyAlterRemoteServiceBindingGets 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.
Public propertyAlterRoleGets 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.
Public propertyAlterRouteGets 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.
Public propertyAlterSchemaGets 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.
Public propertyAlterServiceGets 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.
Public propertyAlterSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterTableGets 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.
Public propertyAlterTriggerGets 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.
Public propertyAlterUserGets 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.
Public propertyAlterViewGets 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.
Public propertyAlterXmlSchemaCollectionGets 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.
Public propertyBindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyBindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateApplicationRoleGets 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.
Public propertyCreateAssemblyGets 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.
Public propertyCreateAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateCertificateGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateContractGets 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.
Public propertyCreateDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created.
Public propertyCreateDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateEventNotificationGets 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.
Public propertyCreateExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is created.
Public propertyCreateFunctionGets 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.
Public propertyCreateIndexGets 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.
Public propertyCreateMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateMessageTypeGets 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.
Public propertyCreatePartitionFunctionGets 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.
Public propertyCreatePartitionSchemeGets 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.
Public propertyCreatePlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateProcedureGets 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.
Public propertyCreateQueueGets 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.
Public propertyCreateRemoteServiceBindingGets 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.
Public propertyCreateRoleGets 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.
Public propertyCreateRouteGets 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.
Public propertyCreateRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSchemaGets 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.
Public propertyCreateServiceGets 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.
Public propertyCreateSpatialIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateStatisticsGets 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.
Public propertyCreateSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSynonymGets 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.
Public propertyCreateTableGets 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.
Public propertyCreateTriggerGets 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.
Public propertyCreateTypeGets 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.
Public propertyCreateUserGets 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.
Public propertyCreateViewGets 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.
Public propertyCreateXmlIndexGets 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.
Public propertyCreateXmlSchemaCollectionGets 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.
Public propertyDdlApplicationRoleEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlAssemblyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlAsymmetricKeyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlAuthorizationDatabaseEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlBrokerPriorityEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlCertificateEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlContractEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlCryptoSignatureEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlDatabaseAuditSpecificationEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlDatabaseEncryptionKeyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlDatabaseLevelEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlDatabaseSecurityEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlDefaultEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlEventNotificationEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlExtendedPropertyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlFulltextCatalogEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlFulltextStoplistEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlFunctionEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlGdrDatabaseEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlIndexEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlMasterKeyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlMessageTypeEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlPartitionEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlPartitionFunctionEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlPartitionSchemeEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlPlanGuideEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlProcedureEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlQueueEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlRemoteServiceBindingEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlRoleEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlRouteEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlRuleEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlSchemaEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlServiceEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlSsbEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlStatisticsEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlSymmetricKeyEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlSynonymEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlTableEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlTableViewEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlTriggerEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlTypeEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlUserEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlViewEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDdlXmlSchemaCollectionEventsEventsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDenyDatabaseGets or sets a Boolean property value that specifies whether events are included in the event set.
Public propertyDirtyGets 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.
Public propertyDropApplicationRoleGets 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.
Public propertyDropAssemblyGets 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.
Public propertyDropAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropCertificateGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropContractGets 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.
Public propertyDropDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
Public propertyDropDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropEventNotificationGets 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.
Public propertyDropExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is dropped.
Public propertyDropFunctionGets 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.
Public propertyDropIndexGets 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.
Public propertyDropMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropMessageTypeGets 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.
Public propertyDropPartitionFunctionGets 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.
Public propertyDropPartitionSchemeGets 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.
Public propertyDropPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropProcedureGets 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.
Public propertyDropQueueGets 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.
Public propertyDropRemoteServiceBindingGets 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.
Public propertyDropRoleGets 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.
Public propertyDropRoleMemberGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropRouteGets 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.
Public propertyDropRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSchemaGets 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.
Public propertyDropServiceGets 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.
Public propertyDropSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropStatisticsGets 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.
Public propertyDropSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSynonymGets 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.
Public propertyDropTableGets 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.
Public propertyDropTriggerGets 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.
Public propertyDropTypeGets 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.
Public propertyDropUserGets 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.
Public propertyDropViewGets 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.
Public propertyDropXmlSchemaCollectionGets 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.
Public propertyGrantDatabaseGets 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.
Public propertyNumberOfElementsGets the number of events that are included in the event set. (Overrides EventSetBase.NumberOfElements.)
Public propertyRenameGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyRevokeDatabaseGets 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.
Protected propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public propertyUnbindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUnbindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUpdateStatisticsGets 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
  NameDescription
Public methodAdd(DatabaseDdlTriggerEvent)Returns a set of database DDL trigger events after adding a new event to the event referenced set.
Public methodStatic memberAdd(DatabaseDdlTriggerEventSet, DatabaseDdlTriggerEvent)Returns a set of database DDL trigger events after adding a new event to the event specified set.
Public methodCopyReturns a copy of the event set. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodFitsMaskSpecifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodHasCommonBitsSpecifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Protected methodSetValueSets the bit value at the specified index position. (Inherited from EventSetBase.)
Public methodStatic memberSubtractReturns a set of database DDL trigger events after removing an event from the event specified set.
Public methodToStringReturns a string that represents the DatabaseDdlTriggerEventSet object. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
Public operatorStatic memberSubtractionCreates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
Top

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

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.