Udostępnij za pośrednictwem


ServerDdlTriggerEventSet Class

Definition

class ServerDdlTriggerEventSet

public sealed class ServerDdlTriggerEventSet : Microsoft.SqlServer.Management.Smo.EventSetBase
type ServerDdlTriggerEventSet = class
    inherit EventSetBase
Public NotInheritable Class ServerDdlTriggerEventSet
Inherits EventSetBase
Inheritance
ServerDdlTriggerEventSet

Constructors

ServerDdlTriggerEventSet()

default constructor

ServerDdlTriggerEventSet(ServerDdlTriggerEvent)

constructor initialize with an event

ServerDdlTriggerEventSet(ServerDdlTriggerEvent[])

constructor initialize with a list of events

ServerDdlTriggerEventSet(ServerDdlTriggerEventSet)

copy constructor

Properties

AddRoleMember

define property for AddRoleMember

AddSensitivityClassification

define property for AddSensitivityClassification

AddServerRoleMember

define property for AddServerRoleMember

AddSignature

define property for AddSignature

AddSignatureSchemaObject

define property for AddSignatureSchemaObject

AlterApplicationRole

define property for AlterApplicationRole

AlterAssembly

define property for AlterAssembly

AlterAsymmetricKey

define property for AlterAsymmetricKey

AlterAudit

define property for AlterAudit

AlterAuthorizationDatabase

define property for AlterAuthorizationDatabase

AlterAuthorizationServer

define property for AlterAuthorizationServer

AlterAvailabilityGroup

define property for AlterAvailabilityGroup

AlterBrokerPriority

define property for AlterBrokerPriority

AlterCertificate

define property for AlterCertificate

AlterColumnEncryptionKey

define property for AlterColumnEncryptionKey

AlterCredential

define property for AlterCredential

AlterCryptographicProvider

define property for AlterCryptographicProvider

AlterDatabase

define property for AlterDatabase

AlterDatabaseAuditSpecification

define property for AlterDatabaseAuditSpecification

AlterDatabaseEncryptionKey

define property for AlterDatabaseEncryptionKey

AlterDatabaseScopedConfiguration

define property for AlterDatabaseScopedConfiguration

AlterEndpoint

define property for AlterEndpoint

AlterEventSession

define property for AlterEventSession

AlterExtendedProperty

define property for AlterExtendedProperty

AlterExternalLanguage

define property for AlterExternalLanguage

AlterExternalLibrary

define property for AlterExternalLibrary

AlterExternalResourcePool

define property for AlterExternalResourcePool

AlterFulltextCatalog

define property for AlterFulltextCatalog

AlterFulltextIndex

define property for AlterFulltextIndex

AlterFulltextStoplist

define property for AlterFulltextStoplist

AlterFunction

define property for AlterFunction

AlterIndex

define property for AlterIndex

AlterInstance

define property for AlterInstance

AlterLinkedServer

define property for AlterLinkedServer

AlterLogin

define property for AlterLogin

AlterMasterKey

define property for AlterMasterKey

AlterMessage

define property for AlterMessage

AlterMessageType

define property for AlterMessageType

AlterPartitionFunction

define property for AlterPartitionFunction

AlterPartitionScheme

define property for AlterPartitionScheme

AlterPlanGuide

define property for AlterPlanGuide

AlterProcedure

define property for AlterProcedure

AlterQueue

define property for AlterQueue

AlterRemoteServer

define property for AlterRemoteServer

AlterRemoteServiceBinding

define property for AlterRemoteServiceBinding

AlterResourceGovernorConfig

define property for AlterResourceGovernorConfig

AlterResourcePool

define property for AlterResourcePool

AlterRole

define property for AlterRole

AlterRoute

define property for AlterRoute

AlterSchema

define property for AlterSchema

AlterSearchPropertyList

define property for AlterSearchPropertyList

AlterSecurityPolicy

define property for AlterSecurityPolicy

AlterSequence

define property for AlterSequence

AlterServerAudit

define property for AlterServerAudit

AlterServerAuditSpecification

define property for AlterServerAuditSpecification

AlterServerRole

define property for AlterServerRole

AlterService

define property for AlterService

AlterServiceMasterKey

define property for AlterServiceMasterKey

AlterSymmetricKey

define property for AlterSymmetricKey

AlterTable

define property for AlterTable

AlterTrigger

define property for AlterTrigger

AlterUser

define property for AlterUser

AlterView

define property for AlterView

AlterWorkloadGroup

define property for AlterWorkloadGroup

AlterXmlSchemaCollection

define property for AlterXmlSchemaCollection

BindDefault

define property for BindDefault

BindRule

define property for BindRule

CreateApplicationRole

define property for CreateApplicationRole

CreateAssembly

define property for CreateAssembly

CreateAsymmetricKey

define property for CreateAsymmetricKey

CreateAudit

define property for CreateAudit

CreateAvailabilityGroup

define property for CreateAvailabilityGroup

CreateBrokerPriority

define property for CreateBrokerPriority

CreateCertificate

define property for CreateCertificate

CreateColumnEncryptionKey

define property for CreateColumnEncryptionKey

CreateColumnMasterKey

define property for CreateColumnMasterKey

CreateContract

define property for CreateContract

CreateCredential

define property for CreateCredential

CreateCryptographicProvider

define property for CreateCryptographicProvider

CreateDatabase

define property for CreateDatabase

CreateDatabaseAuditSpecification

define property for CreateDatabaseAuditSpecification

CreateDatabaseEncryptionKey

define property for CreateDatabaseEncryptionKey

CreateDefault

define property for CreateDefault

CreateEndpoint

define property for CreateEndpoint

CreateEventNotification

define property for CreateEventNotification

CreateEventSession

define property for CreateEventSession

CreateExtendedProcedure

define property for CreateExtendedProcedure

CreateExtendedProperty

define property for CreateExtendedProperty

CreateExternalLanguage

define property for CreateExternalLanguage

CreateExternalLibrary

define property for CreateExternalLibrary

CreateExternalResourcePool

define property for CreateExternalResourcePool

CreateFulltextCatalog

define property for CreateFulltextCatalog

CreateFulltextIndex

define property for CreateFulltextIndex

CreateFulltextStoplist

define property for CreateFulltextStoplist

CreateFunction

define property for CreateFunction

CreateIndex

define property for CreateIndex

CreateLinkedServer

define property for CreateLinkedServer

CreateLinkedServerLogin

define property for CreateLinkedServerLogin

CreateLogin

define property for CreateLogin

CreateMasterKey

define property for CreateMasterKey

CreateMessage

define property for CreateMessage

CreateMessageType

define property for CreateMessageType

CreatePartitionFunction

define property for CreatePartitionFunction

CreatePartitionScheme

define property for CreatePartitionScheme

CreatePlanGuide

define property for CreatePlanGuide

CreateProcedure

define property for CreateProcedure

CreateQueue

define property for CreateQueue

CreateRemoteServer

define property for CreateRemoteServer

CreateRemoteServiceBinding

define property for CreateRemoteServiceBinding

CreateResourcePool

define property for CreateResourcePool

CreateRole

define property for CreateRole

CreateRoute

define property for CreateRoute

CreateRule

define property for CreateRule

CreateSchema

define property for CreateSchema

CreateSearchPropertyList

define property for CreateSearchPropertyList

CreateSecurityPolicy

define property for CreateSecurityPolicy

CreateSequence

define property for CreateSequence

CreateServerAudit

define property for CreateServerAudit

CreateServerAuditSpecification

define property for CreateServerAuditSpecification

CreateServerRole

define property for CreateServerRole

CreateService

define property for CreateService

CreateSpatialIndex

define property for CreateSpatialIndex

CreateStatistics

define property for CreateStatistics

CreateSymmetricKey

define property for CreateSymmetricKey

CreateSynonym

define property for CreateSynonym

CreateTable

define property for CreateTable

CreateTrigger

define property for CreateTrigger

CreateType

define property for CreateType

CreateUser

define property for CreateUser

CreateView

define property for CreateView

CreateWorkloadGroup

define property for CreateWorkloadGroup

CreateXmlIndex

define property for CreateXmlIndex

CreateXmlSchemaCollection

define property for CreateXmlSchemaCollection

DdlAuthorizationServerEventsEvents

get/set all events for ddlauthorizationservereventsevents

DdlAvailabilityGroupEventsEvents

get/set all events for ddlavailabilitygroupeventsevents

DdlCredentialEventsEvents

get/set all events for ddlcredentialeventsevents

DdlCryptographicProviderEventsEvents

get/set all events for ddlcryptographicprovidereventsevents

DdlDatabaseEventsEvents

get/set all events for ddldatabaseeventsevents

DdlEndpointEventsEvents

get/set all events for ddlendpointeventsevents

DdlEventSessionEventsEvents

get/set all events for ddleventsessioneventsevents

DdlExtendedProcedureEventsEvents

get/set all events for ddlextendedprocedureeventsevents

DdlExternalResourcePoolEventsEvents

get/set all events for ddlexternalresourcepooleventsevents

DdlGdrServerEventsEvents

get/set all events for ddlgdrservereventsevents

DdlLinkedServerEventsEvents

get/set all events for ddllinkedservereventsevents

DdlLinkedServerLoginEventsEvents

get/set all events for ddllinkedserverlogineventsevents

DdlLoginEventsEvents

get/set all events for ddllogineventsevents

DdlMessageEventsEvents

get/set all events for ddlmessageeventsevents

DdlRemoteServerEventsEvents

get/set all events for ddlremoteservereventsevents

DdlResourceGovernorEventsEvents

get/set all events for ddlresourcegovernoreventsevents

DdlResourcePoolEvents

get/set all events for ddlresourcepoolevents

DdlServerAuditEventsEvents

get/set all events for ddlserverauditeventsevents

DdlServerAuditSpecificationEventsEvents

get/set all events for ddlserverauditspecificationeventsevents

DdlServerLevelEventsEvents

get/set all events for ddlserverleveleventsevents

DdlServerSecurityEventsEvents

get/set all events for ddlserversecurityeventsevents

DdlServiceMasterKeyEventsEvents

get/set all events for ddlservicemasterkeyeventsevents

DdlWorkloadGroupEvents

get/set all events for ddlworkloadgroupevents

DenyDatabase

define property for DenyDatabase

DenyServer

define property for DenyServer

Dirty

true if the event set has been modified

DropApplicationRole

define property for DropApplicationRole

DropAssembly

define property for DropAssembly

DropAsymmetricKey

define property for DropAsymmetricKey

DropAudit

define property for DropAudit

DropAvailabilityGroup

define property for DropAvailabilityGroup

DropBrokerPriority

define property for DropBrokerPriority

DropCertificate

define property for DropCertificate

DropColumnEncryptionKey

define property for DropColumnEncryptionKey

DropColumnMasterKey

define property for DropColumnMasterKey

DropContract

define property for DropContract

DropCredential

define property for DropCredential

DropCryptographicProvider

define property for DropCryptographicProvider

DropDatabase

define property for DropDatabase

DropDatabaseAuditSpecification

define property for DropDatabaseAuditSpecification

DropDatabaseEncryptionKey

define property for DropDatabaseEncryptionKey

DropDefault

define property for DropDefault

DropEndpoint

define property for DropEndpoint

DropEventNotification

define property for DropEventNotification

DropEventSession

define property for DropEventSession

DropExtendedProcedure

define property for DropExtendedProcedure

DropExtendedProperty

define property for DropExtendedProperty

DropExternalLanguage

define property for DropExternalLanguage

DropExternalLibrary

define property for DropExternalLibrary

DropExternalResourcePool

define property for DropExternalResourcePool

DropFulltextCatalog

define property for DropFulltextCatalog

DropFulltextIndex

define property for DropFulltextIndex

DropFulltextStoplist

define property for DropFulltextStoplist

DropFunction

define property for DropFunction

DropIndex

define property for DropIndex

DropLinkedServer

define property for DropLinkedServer

DropLinkedServerLogin

define property for DropLinkedServerLogin

DropLogin

define property for DropLogin

DropMasterKey

define property for DropMasterKey

DropMessage

define property for DropMessage

DropMessageType

define property for DropMessageType

DropPartitionFunction

define property for DropPartitionFunction

DropPartitionScheme

define property for DropPartitionScheme

DropPlanGuide

define property for DropPlanGuide

DropProcedure

define property for DropProcedure

DropQueue

define property for DropQueue

DropRemoteServer

define property for DropRemoteServer

DropRemoteServiceBinding

define property for DropRemoteServiceBinding

DropResourcePool

define property for DropResourcePool

DropRole

define property for DropRole

DropRoleMember

define property for DropRoleMember

DropRoute

define property for DropRoute

DropRule

define property for DropRule

DropSchema

define property for DropSchema

DropSearchPropertyList

define property for DropSearchPropertyList

DropSecurityPolicy

define property for DropSecurityPolicy

DropSensitivityClassification

define property for DropSensitivityClassification

DropSequence

define property for DropSequence

DropServerAudit

define property for DropServerAudit

DropServerAuditSpecification

define property for DropServerAuditSpecification

DropServerRole

define property for DropServerRole

DropServerRoleMember

define property for DropServerRoleMember

DropService

define property for DropService

DropSignature

define property for DropSignature

DropSignatureSchemaObject

define property for DropSignatureSchemaObject

DropStatistics

define property for DropStatistics

DropSymmetricKey

define property for DropSymmetricKey

DropSynonym

define property for DropSynonym

DropTable

define property for DropTable

DropTrigger

define property for DropTrigger

DropType

define property for DropType

DropUser

define property for DropUser

DropView

define property for DropView

DropWorkloadGroup

define property for DropWorkloadGroup

DropXmlSchemaCollection

define property for DropXmlSchemaCollection

GrantDatabase

define property for GrantDatabase

GrantServer

define property for GrantServer

Logon

define property for Logon

NumberOfElements

return number of elements

Rename

define property for Rename

RevokeDatabase

define property for RevokeDatabase

RevokeServer

define property for RevokeServer

Storage

bit storage

(Inherited from EventSetBase)
UnbindDefault

define property for UnbindDefault

UnbindRule

define property for UnbindRule

UpdateStatistics

define property for UpdateStatistics

Methods

Add(ServerDdlTriggerEvent)

set bit for an event

Add(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)

add an event

Copy()

copy

FitsMask(EventSetBase)

true if fits the mask

(Inherited from EventSetBase)
HasCommonBits(EventSetBase)

returns true if this and optCompare have common options that are set

(Inherited from EventSetBase)
Remove(ServerDdlTriggerEvent)

reset bit for an event

SetValue(EventSetBase, Boolean)

set value

(Inherited from EventSetBase)
Subtract(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)

remove an event

ToString()

return string representation

Operators

Addition(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)

add an event

Subtraction(ServerDdlTriggerEventSet, ServerDdlTriggerEvent)

remove an event

Applies to