مشاركة عبر

ServerDdlTriggerEventSet Class

  • مقالة

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

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class ServerDdlTriggerEventSet _
    Inherits EventSetBase
'Usage
Dim instance As ServerDdlTriggerEventSet

public sealed class ServerDdlTriggerEventSet : EventSetBase

public ref class ServerDdlTriggerEventSet sealed : public EventSetBase

[<SealedAttribute>]
type ServerDdlTriggerEventSet =  
    class 
        inherit EventSetBase 
    end

public final class ServerDdlTriggerEventSet extends EventSetBase

The ServerDdlTriggerEventSet type exposes the following members.

Constructors

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

Top

Properties

  Name Description
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property AlterAvailabilityGroup Gets or sets a value that indicates whether the AlterAvailabilityGroup event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property CreateAvailabilityGroup Gets or sets a value that indicates whether the CreateAvailabilityGroup event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DdlAvailabilityGroupEventsEvents Gets or sets a value that indicates whether the DdlAvailabilityGroupEventsEvents event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property Dirty Gets or sets a Boolean property value that specifies whether the event set has been modified.
Public property 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.
Public property 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.
Public property 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.
Public property DropAvailabilityGroup Gets or sets a value that indicates whether the DropAvailabilityGroup event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DropFunction Gets or sets a Boolean value that specifies whether the DropFunction event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property NumberOfElements Gets the number of events in the event set. (Overrides EventSetBase.NumberOfElements.)
Public property 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.
Public property 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.
Public property 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.
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public property 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.
Public property 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.
Public property 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.

Top

Methods

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

Top

Operators

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

Top

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.

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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events