DatabaseDdlTriggerEventSet Class
TOC
Collapse the table of content
Expand the table of content

DatabaseDdlTriggerEventSet Class

 

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

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

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

public ref class DatabaseDdlTriggerEventSet sealed : EventSetBase

NameDescription
System_CAPS_pubmethodDatabaseDdlTriggerEventSet()

Initializes a new instance of the DatabaseDdlTriggerEventSet class.

System_CAPS_pubmethodDatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent^)

Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

System_CAPS_pubmethodDatabaseDdlTriggerEventSet(array<DatabaseDdlTriggerEvent^>^)

Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

System_CAPS_pubmethodDatabaseDdlTriggerEventSet(DatabaseDdlTriggerEventSet^)

Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

NameDescription
System_CAPS_pubpropertyAddRoleMember

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAddSignature

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAddSignatureSchemaObject

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterApplicationRole

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.

System_CAPS_pubpropertyAlterAssembly

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.

System_CAPS_pubpropertyAlterAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterAuthorizationDatabase

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.

System_CAPS_pubpropertyAlterBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterCertificate

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterColumnEncryptionKey

System_CAPS_pubpropertyAlterDatabaseAuditSpecification

Gets 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.

System_CAPS_pubpropertyAlterDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextStoplist

Gets 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.

System_CAPS_pubpropertyAlterFunction

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.

System_CAPS_pubpropertyAlterIndex

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.

System_CAPS_pubpropertyAlterMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterMessageType

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.

System_CAPS_pubpropertyAlterPartitionFunction

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.

System_CAPS_pubpropertyAlterPartitionScheme

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.

System_CAPS_pubpropertyAlterPlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterProcedure

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.

System_CAPS_pubpropertyAlterQueue

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.

System_CAPS_pubpropertyAlterRemoteServiceBinding

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.

System_CAPS_pubpropertyAlterRole

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.

System_CAPS_pubpropertyAlterRoute

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.

System_CAPS_pubpropertyAlterSchema

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.

System_CAPS_pubpropertyAlterSearchPropertyList

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterSecurityPolicy

System_CAPS_pubpropertyAlterSequence

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterService

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.

System_CAPS_pubpropertyAlterSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterTable

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.

System_CAPS_pubpropertyAlterTrigger

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.

System_CAPS_pubpropertyAlterUser

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.

System_CAPS_pubpropertyAlterView

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.

System_CAPS_pubpropertyAlterXmlSchemaCollection

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.

System_CAPS_pubpropertyBindDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyBindRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateApplicationRole

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.

System_CAPS_pubpropertyCreateAssembly

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.

System_CAPS_pubpropertyCreateAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateCertificate

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateColumnEncryptionKey

System_CAPS_pubpropertyCreateColumnMasterKey

System_CAPS_pubpropertyCreateContract

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.

System_CAPS_pubpropertyCreateDatabaseAuditSpecification

Gets 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.

System_CAPS_pubpropertyCreateDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateEventNotification

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.

System_CAPS_pubpropertyCreateExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextStoplist

Gets 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.

System_CAPS_pubpropertyCreateFunction

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.

System_CAPS_pubpropertyCreateIndex

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.

System_CAPS_pubpropertyCreateMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateMessageType

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.

System_CAPS_pubpropertyCreatePartitionFunction

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.

System_CAPS_pubpropertyCreatePartitionScheme

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.

System_CAPS_pubpropertyCreatePlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateProcedure

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.

System_CAPS_pubpropertyCreateQueue

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.

System_CAPS_pubpropertyCreateRemoteServiceBinding

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.

System_CAPS_pubpropertyCreateRole

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.

System_CAPS_pubpropertyCreateRoute

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.

System_CAPS_pubpropertyCreateRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateSchema

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.

System_CAPS_pubpropertyCreateSearchPropertyList

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateSecurityPolicy

System_CAPS_pubpropertyCreateSequence

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateService

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.

System_CAPS_pubpropertyCreateSpatialIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateStatistics

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.

System_CAPS_pubpropertyCreateSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateSynonym

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.

System_CAPS_pubpropertyCreateTable

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.

System_CAPS_pubpropertyCreateTrigger

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.

System_CAPS_pubpropertyCreateType

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.

System_CAPS_pubpropertyCreateUser

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.

System_CAPS_pubpropertyCreateView

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.

System_CAPS_pubpropertyCreateXmlIndex

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.

System_CAPS_pubpropertyCreateXmlSchemaCollection

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.

System_CAPS_pubpropertyDdlApplicationRoleEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlAssemblyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlAsymmetricKeyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlAuthorizationDatabaseEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlBrokerPriorityEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlCertificateEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlColumnEncryptionKeyEventsEvents

System_CAPS_pubpropertyDdlColumnMasterKeyEventsEvents

System_CAPS_pubpropertyDdlContractEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlCryptoSignatureEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDatabaseAuditEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDatabaseAuditSpecificationEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDatabaseEncryptionKeyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDatabaseLevelEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDatabaseSecurityEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlDefaultEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlEventNotificationEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlExtendedPropertyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlFulltextCatalogEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlFulltextStoplistEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlFunctionEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlGdrDatabaseEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlIndexEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlMasterKeyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlMessageTypeEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlPartitionEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlPartitionFunctionEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlPartitionSchemeEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlPlanGuideEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlProcedureEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlQueueEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlRemoteServiceBindingEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlRoleEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlRouteEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlRuleEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSchemaEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSearchPropertyListEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSecurityPolicyEventsEvents

System_CAPS_pubpropertyDdlSequenceEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlServiceEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSsbEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlStatisticsEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSymmetricKeyEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlSynonymEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlTableEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlTableViewEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlTriggerEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlTypeEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlUserEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlViewEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDdlXmlSchemaCollectionEventsEvents

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDenyDatabase

Gets or sets a Boolean property value that specifies whether events are included in the event set.

System_CAPS_pubpropertyDirty

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.

System_CAPS_pubpropertyDropApplicationRole

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.

System_CAPS_pubpropertyDropAssembly

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.

System_CAPS_pubpropertyDropAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropCertificate

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropColumnEncryptionKey

System_CAPS_pubpropertyDropColumnMasterKey

System_CAPS_pubpropertyDropContract

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.

System_CAPS_pubpropertyDropDatabaseAuditSpecification

Gets 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.

System_CAPS_pubpropertyDropDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropEventNotification

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.

System_CAPS_pubpropertyDropExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextStoplist

Gets 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.

System_CAPS_pubpropertyDropFunction

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.

System_CAPS_pubpropertyDropIndex

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.

System_CAPS_pubpropertyDropMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropMessageType

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.

System_CAPS_pubpropertyDropPartitionFunction

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.

System_CAPS_pubpropertyDropPartitionScheme

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.

System_CAPS_pubpropertyDropPlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropProcedure

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.

System_CAPS_pubpropertyDropQueue

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.

System_CAPS_pubpropertyDropRemoteServiceBinding

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.

System_CAPS_pubpropertyDropRole

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.

System_CAPS_pubpropertyDropRoleMember

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropRoute

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.

System_CAPS_pubpropertyDropRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSchema

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.

System_CAPS_pubpropertyDropSearchPropertyList

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSecurityPolicy

System_CAPS_pubpropertyDropSequence

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropService

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.

System_CAPS_pubpropertyDropSignature

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSignatureSchemaObject

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropStatistics

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.

System_CAPS_pubpropertyDropSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSynonym

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.

System_CAPS_pubpropertyDropTable

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.

System_CAPS_pubpropertyDropTrigger

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.

System_CAPS_pubpropertyDropType

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.

System_CAPS_pubpropertyDropUser

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.

System_CAPS_pubpropertyDropView

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.

System_CAPS_pubpropertyDropXmlSchemaCollection

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.

System_CAPS_pubpropertyGrantDatabase

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.

System_CAPS_pubpropertyNumberOfElements

Gets the number of events that are included in the event set.(Overrides EventSetBase::NumberOfElements.)

System_CAPS_pubpropertyRename

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyRevokeDatabase

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.

System_CAPS_protpropertyStorage

Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

System_CAPS_pubpropertyUnbindDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyUnbindRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyUpdateStatistics

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.

NameDescription
System_CAPS_pubmethodAdd(DatabaseDdlTriggerEvent^)

Returns a set of database DDL trigger events after adding a new event to the event referenced set.

System_CAPS_pubmethodSystem_CAPS_staticAdd(DatabaseDdlTriggerEventSet^, DatabaseDdlTriggerEvent^)

Returns a set of database DDL trigger events after adding a new event to the event specified set.

System_CAPS_pubmethodCopy()

Returns a copy of the event set.(Overrides EventSetBase::Copy().)

System_CAPS_pubmethodEquals(Object^)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(DatabaseDdlTriggerEvent^)

Removes an event from the event set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(DatabaseDdlTriggerEventSet^, DatabaseDdlTriggerEvent^)

Returns a set of database DDL trigger events after removing an event from the event specified set.

System_CAPS_pubmethodToString()

Returns a string that represents the DatabaseDdlTriggerEventSet object.(Overrides Object::ToString().)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(DatabaseDdlTriggerEventSet^, DatabaseDdlTriggerEvent^)

Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(DatabaseDdlTriggerEventSet^, DatabaseDdlTriggerEvent^)

Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.

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.

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.

Return to top
Show:
© 2016 Microsoft