ServerDdlTriggerEventSet Class

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

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

Inheritance Hierarchy

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

Syntax

C++

public sealed class ServerDdlTriggerEventSet : EventSetBase

Constructors

	Name	Description
	ServerDdlTriggerEventSet()	Initializes a new instance of the ServerDdlTriggerEventSet class.
	ServerDdlTriggerEventSet(ServerDdlTriggerEvent)	Initializes a new instance of the ServerDdlTriggerEventSet class with the specified event.
	ServerDdlTriggerEventSet(ServerDdlTriggerEvent[])	Initializes a new instance of the ServerDdlTriggerEventSet class with the specified set of events.
	ServerDdlTriggerEventSet(ServerDdlTriggerEventSet)	Initializes a new instance of the ServerDdlTriggerEventSet class with the specified set of events

Properties

	Name	Description
	AddRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AddServerRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AddSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AddSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	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 server is altered.
	AlterAuthorizationServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterAvailabilityGroup	Gets or sets a value that indicates whether the AlterAvailabilityGroup event is included in the event set.
	AlterBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is altered.
	AlterColumnEncryptionKey	Gets or sets a value that indicates whether to column encryption key.
	AlterCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a HTTP endpoint is altered.
	AlterEventSession	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterInstance	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is altered.
	AlterMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterMessage	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterResourceGovernorConfig	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterSearchPropertyList	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterSecurityPolicy	Gets or sets a value that indicates whether the server alters security policy.
	AlterSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterServerRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterServiceMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	AlterXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	BindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	BindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateAvailabilityGroup	Gets or sets a value that indicates whether the CreateAvailabilityGroup event is included in the event set.
	CreateBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is created.
	CreateColumnEncryptionKey	Gets or sets a value that indicates whether the event creates column encryption key.
	CreateColumnMasterKey	Gets or sets a value that indicates whether the server creates column master key.
	CreateContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an HTTP endpoint is created.
	CreateEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateEventSession	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateExtendedProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateLinkedServerLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is created.
	CreateMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateMessage	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreatePartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreatePartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreatePlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSearchPropertyList	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSecurityPolicy	Gets or sets a value whether the server creates security policy.
	CreateSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateServerRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSpatialIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateXmlIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	CreateXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlAuthorizationServerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlAvailabilityGroupEventsEvents	Gets or sets a value that indicates whether the DdlAvailabilityGroupEventsEvents event is included in the event set.
	DdlCredentialEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlCryptographicProviderEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlDatabaseEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlEndpointEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlEventSessionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlExtendedProcedureEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlGdrServerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlLinkedServerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlLinkedServerLoginEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlLoginEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlMessageEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlRemoteServerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlResourceGovernorEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlResourcePoolEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlServerAuditEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlServerAuditSpecificationEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlServerLevelEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlServerSecurityEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlServiceMasterKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DdlWorkloadGroupEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DenyServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a permission is denied on the server.
	Dirty	Gets or sets a Boolean property value that specifies whether the event set has been modified.
	DropApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropAvailabilityGroup	Gets or sets a value that indicates whether the DropAvailabilityGroup event is included in the event set.
	DropBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event certificate events are included in the event set.
	DropColumnEncryptionKey	Gets or sets the DropColumnEncryptionKey.
	DropColumnMasterKey	Gets or sets a value that indicates whether to drop column master key.
	DropContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an HTTP endpoint is dropped.
	DropEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropEventSession	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropExtendedProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropFunction	Gets or sets a Boolean value that specifies whether the DropFunction event is included in the event set.
	DropIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropLinkedServerLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is dropped.
	DropMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropMessage	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSearchPropertyList	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSecurityPolicy	Gets or sets a value that indicates whether the server Ddl trigger event set removed in the security policy.
	DropSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropServerRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropServerRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	DropXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	GrantServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a permission is granted on the server.
	Logon	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	NumberOfElements	Gets the number of events in the event set.(Overrides EventSetBase.NumberOfElements.)
	Rename	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	RevokeDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	RevokeServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a permission is revoked on the server.
	Storage	Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
	UnbindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	UnbindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server is altered.

Methods

	Name	Description
	Add(ServerDdlTriggerEvent)	Returns a set of server DDL events after adding a new server DDL event to the set of events.
	Add(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)	Returns a set of server DDL events after adding a new server DDL event to the specified set of events.
	Copy()	Returns a copy of the event set.(Overrides EventSetBase.Copy().)
	Equals(Object)	(Inherited from Object.)
	GetHashCode()	(Inherited from Object.)
	GetType()	(Inherited from Object.)
	Remove(ServerDdlTriggerEvent)	Removes an event from the event set.
	Subtract(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)	Returns a set of server DDL trigger events after subtracting a DDL trigger event from the specified set of event set.
	ToString()	Returns a string that represents the ServerDdlTriggerEventSet object.(Overrides Object.ToString().)

Operators

	Name	Description
	Addition(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)	Creates a server data definition language (DDL) trigger event set by performing an addition operation on a ServerDdlTriggerEvent object and a ServerDdlTriggerEventSet object.
	Subtraction(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)	Creates a server data definition language (DDL) trigger event set by performing a subtraction operation on a ServerDdlTriggerEvent object and a ServerDdlTriggerEventSet object.

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

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.

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

ServerDdlTriggerEventSet Class

Inheritance Hierarchy

Syntax

Constructors

Properties

Methods

Operators

Remarks

Thread Safety

Examples

Thread Safety

See Also