ServerDdlTriggerEventSet ServerDdlTriggerEventSet ServerDdlTriggerEventSet Class

Definition

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

public ref class ServerDdlTriggerEventSet sealed : Microsoft::SqlServer::Management::Smo::EventSetBase
public sealed class ServerDdlTriggerEventSet : Microsoft.SqlServer.Management.Smo.EventSetBase
Public NotInheritable Class ServerDdlTriggerEventSet
Inherits EventSetBase
Inheritance
ServerDdlTriggerEventSetServerDdlTriggerEventSetServerDdlTriggerEventSet

Examples

Handling SMO Events

Remarks

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.

Constructors

ServerDdlTriggerEventSet() ServerDdlTriggerEventSet() ServerDdlTriggerEventSet()

Initializes a new instance of the ServerDdlTriggerEventSet class.

ServerDdlTriggerEventSet(ServerDdlTriggerEvent) ServerDdlTriggerEventSet(ServerDdlTriggerEvent) ServerDdlTriggerEventSet(ServerDdlTriggerEvent)

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

ServerDdlTriggerEventSet(ServerDdlTriggerEventSet) ServerDdlTriggerEventSet(ServerDdlTriggerEventSet) ServerDdlTriggerEventSet(ServerDdlTriggerEventSet)

Initializes a new instance of the ServerDdlTriggerEventSet class with the specified set of events

ServerDdlTriggerEventSet(ServerDdlTriggerEvent[]) ServerDdlTriggerEventSet(ServerDdlTriggerEvent[]) ServerDdlTriggerEventSet(ServerDdlTriggerEvent[])

Initializes a new instance of the ServerDdlTriggerEventSet class with the specified set of events.

Properties

AddRoleMember AddRoleMember 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 AddServerRoleMember 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 AddSignature 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 AddSignatureSchemaObject 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 AlterApplicationRole 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 AlterAssembly 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 AlterAsymmetricKey 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.

AlterAudit AlterAudit AlterAudit
AlterAuthorizationDatabase AlterAuthorizationDatabase 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 AlterAuthorizationServer 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 AlterAvailabilityGroup AlterAvailabilityGroup

Gets or sets a value that indicates whether the AlterAvailabilityGroup event is included in the event set.

AlterBrokerPriority AlterBrokerPriority 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 AlterCertificate 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 AlterColumnEncryptionKey AlterColumnEncryptionKey

Gets or sets a value that indicates whether to column encryption key.

AlterCredential AlterCredential 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 AlterCryptographicProvider 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 AlterDatabase 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 AlterDatabaseAuditSpecification 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 AlterDatabaseEncryptionKey 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 AlterEndpoint 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 AlterEventSession 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 AlterExtendedProperty 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 AlterFulltextCatalog 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 AlterFulltextIndex 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 AlterFulltextStoplist 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 AlterFunction 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 AlterIndex 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 AlterInstance 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 AlterLinkedServer 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 AlterLogin 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 AlterMasterKey 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 AlterMessage 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 AlterMessageType 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 AlterPartitionFunction 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 AlterPartitionScheme 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 AlterPlanGuide 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 AlterProcedure 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 AlterQueue 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 AlterRemoteServer 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 AlterRemoteServiceBinding 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 AlterResourceGovernorConfig 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 AlterResourcePool 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 AlterRole 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 AlterRoute 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 AlterSchema 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 AlterSearchPropertyList 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 AlterSecurityPolicy AlterSecurityPolicy

Gets or sets a value that indicates whether the server alters security policy.

AlterSequence AlterSequence 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 AlterServerAudit 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 AlterServerAuditSpecification 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 AlterServerRole 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 AlterService 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 AlterServiceMasterKey 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 AlterSymmetricKey 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 AlterTable 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 AlterTrigger 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 AlterUser 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 AlterView 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 AlterWorkloadGroup 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 AlterXmlSchemaCollection 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 BindDefault 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 BindRule 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 CreateApplicationRole 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 CreateAssembly 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 CreateAsymmetricKey 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.

CreateAudit CreateAudit CreateAudit
CreateAvailabilityGroup CreateAvailabilityGroup CreateAvailabilityGroup

Gets or sets a value that indicates whether the CreateAvailabilityGroup event is included in the event set.

CreateBrokerPriority CreateBrokerPriority 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 CreateCertificate 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 CreateColumnEncryptionKey CreateColumnEncryptionKey

Gets or sets a value that indicates whether the event creates column encryption key.

CreateColumnMasterKey CreateColumnMasterKey CreateColumnMasterKey

Gets or sets a value that indicates whether the server creates column master key.

CreateContract CreateContract 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 CreateCredential 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 CreateCryptographicProvider 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 CreateDatabase 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 CreateDatabaseAuditSpecification 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 CreateDatabaseEncryptionKey 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 CreateDefault 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 CreateEndpoint 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 CreateEventNotification 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 CreateEventSession 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 CreateExtendedProcedure 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 CreateExtendedProperty 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 CreateFulltextCatalog 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 CreateFulltextIndex 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 CreateFulltextStoplist 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 CreateFunction 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 CreateIndex 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 CreateLinkedServer 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 CreateLinkedServerLogin 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 CreateLogin 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 CreateMasterKey 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 CreateMessage 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 CreateMessageType 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 CreatePartitionFunction 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 CreatePartitionScheme 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 CreatePlanGuide 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 CreateProcedure 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 CreateQueue 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 CreateRemoteServer 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 CreateRemoteServiceBinding 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 CreateResourcePool 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 CreateRole 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 CreateRoute 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 CreateRule 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 CreateSchema 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 CreateSearchPropertyList 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 CreateSecurityPolicy CreateSecurityPolicy

Gets or sets a value whether the server creates security policy.

CreateSequence CreateSequence 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 CreateServerAudit 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 CreateServerAuditSpecification 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 CreateServerRole 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 CreateService 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 CreateSpatialIndex 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 CreateStatistics 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 CreateSymmetricKey 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 CreateSynonym 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 CreateTable 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 CreateTrigger 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 CreateType 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 CreateUser 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 CreateView 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 CreateWorkloadGroup 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 CreateXmlIndex 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 CreateXmlSchemaCollection 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 DdlAuthorizationServerEventsEvents 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 DdlAvailabilityGroupEventsEvents DdlAvailabilityGroupEventsEvents

Gets or sets a value that indicates whether the DdlAvailabilityGroupEventsEvents event is included in the event set.

DdlCredentialEventsEvents DdlCredentialEventsEvents 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 DdlCryptographicProviderEventsEvents 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 DdlDatabaseEventsEvents 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 DdlEndpointEventsEvents 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 DdlEventSessionEventsEvents 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 DdlExtendedProcedureEventsEvents 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 DdlGdrServerEventsEvents 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 DdlLinkedServerEventsEvents 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 DdlLinkedServerLoginEventsEvents 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 DdlLoginEventsEvents 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 DdlMessageEventsEvents 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 DdlRemoteServerEventsEvents 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 DdlResourceGovernorEventsEvents 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 DdlResourcePoolEvents 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 DdlServerAuditEventsEvents 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 DdlServerAuditSpecificationEventsEvents 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 DdlServerLevelEventsEvents 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 DdlServerSecurityEventsEvents 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 DdlServiceMasterKeyEventsEvents 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 DdlWorkloadGroupEvents 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 DenyDatabase 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 DenyServer 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 Dirty Dirty

Gets or sets a Boolean property value that specifies whether the event set has been modified.

DropApplicationRole DropApplicationRole 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 DropAssembly 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 DropAsymmetricKey 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.

DropAudit DropAudit DropAudit
DropAvailabilityGroup DropAvailabilityGroup DropAvailabilityGroup

Gets or sets a value that indicates whether the DropAvailabilityGroup event is included in the event set.

DropBrokerPriority DropBrokerPriority 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 DropCertificate 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 DropColumnEncryptionKey DropColumnEncryptionKey

Gets or sets the DropColumnEncryptionKey.

DropColumnMasterKey DropColumnMasterKey DropColumnMasterKey

Gets or sets a value that indicates whether to drop column master key.

DropContract DropContract 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 DropCredential 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 DropCryptographicProvider 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 DropDatabase 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 DropDatabaseAuditSpecification 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 DropDatabaseEncryptionKey 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 DropDefault 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 DropEndpoint 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 DropEventNotification 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 DropEventSession 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 DropExtendedProcedure 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 DropExtendedProperty 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 DropFulltextCatalog 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 DropFulltextIndex 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 DropFulltextStoplist 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 DropFunction DropFunction

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

DropIndex DropIndex 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 DropLinkedServer 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 DropLinkedServerLogin 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 DropLogin 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 DropMasterKey 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 DropMessage 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 DropMessageType 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 DropPartitionFunction 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 DropPartitionScheme 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 DropPlanGuide 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 DropProcedure 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 DropQueue 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 DropRemoteServer 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 DropRemoteServiceBinding 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 DropResourcePool 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 DropRole 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 DropRoleMember 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 DropRoute 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 DropRule 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 DropSchema 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 DropSearchPropertyList 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 DropSecurityPolicy DropSecurityPolicy

Gets or sets a value that indicates whether the server Ddl trigger event set removed in the security policy.

DropSequence DropSequence 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 DropServerAudit 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 DropServerAuditSpecification 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 DropServerRole 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 DropServerRoleMember 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 DropService 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 DropSignature 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 DropSignatureSchemaObject 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 DropStatistics 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 DropSymmetricKey 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 DropSynonym 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 DropTable 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 DropTrigger 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 DropType 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 DropUser 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 DropView 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 DropWorkloadGroup 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 DropXmlSchemaCollection 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 GrantDatabase 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 GrantServer 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 Logon 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 NumberOfElements NumberOfElements

Gets the number of events in the event set.

Rename Rename 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 RevokeDatabase 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 RevokeServer 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 Storage Storage

Gets or sets the bit array for event set storage.

(Inherited from EventSetBase)
UnbindDefault UnbindDefault 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 UnbindRule 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 UpdateStatistics 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

Add(ServerDdlTriggerEvent) Add(ServerDdlTriggerEvent) Add(ServerDdlTriggerEvent)

Returns a set of server DDL events after adding a new server DDL event to the set of events.

Add(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) Add(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) Add(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)

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

Copy() Copy() Copy()

Returns a copy of the event set.

FitsMask(EventSetBase) FitsMask(EventSetBase) FitsMask(EventSetBase)

Specifies whether the EventSetBase object fits the specified mask.

(Inherited from EventSetBase)
HasCommonBits(EventSetBase) HasCommonBits(EventSetBase) HasCommonBits(EventSetBase)

Specifies whether the EventSetBase object has common bits with another specified EventSetBase object.

(Inherited from EventSetBase)
Remove(ServerDdlTriggerEvent) Remove(ServerDdlTriggerEvent) Remove(ServerDdlTriggerEvent)

Removes an event from the event set.

SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean)

Sets the bit value at the specified index position.

(Inherited from EventSetBase)
Subtract(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) Subtract(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) 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() ToString() ToString()

Returns a string that represents the ServerDdlTriggerEventSet object.

Operators

Addition(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) Addition(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) 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) Subtraction(ServerDdlTriggerEventSet, ServerDdlTriggerEvent) 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.

Applies to