Udostępnij przez

ServerDdlTriggerEventSet Members

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

The following tables list the members exposed by the ServerDdlTriggerEventSet type.

Public Constructors

  Name Description
ServerDdlTriggerEventSet Overloaded. Initializes a new instance of the ServerDdlTriggerEventSet class.

Top

Public Properties

(see also Protected Properties )

  Name Description
ms220197.pubproperty(pl-pl,SQL.100).gif AddRoleMember  
ms220197.pubproperty(pl-pl,SQL.100).gif AddServerRoleMember  
ms220197.pubproperty(pl-pl,SQL.100).gif AddSignature  
ms220197.pubproperty(pl-pl,SQL.100).gif AddSignatureSchemaObject  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterApplicationRole  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterAssembly  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterAsymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterAuthorizationDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif AlterBrokerPriority  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif AlterCredential  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterCryptographicProvider  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterDatabaseAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterDatabaseEncryptionKey  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif AlterEventSession  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterExtendedProperty  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterFulltextCatalog  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterFulltextIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterFulltextStoplist  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterInstance  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterLinkedServer  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif AlterMasterKey  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterMessage  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterMessageType  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterPartitionFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterPartitionScheme  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterPlanGuide  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterProcedure  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterQueue  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterRemoteServer  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterRemoteServiceBinding  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterResourceGovernorConfig  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterResourcePool  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterRole  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterRoute  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterSchema  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterServerAudit  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterServerAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterService  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterServiceMasterKey  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterSymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterTable  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterTrigger  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterUser  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterView  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterWorkloadGroup  
ms220197.pubproperty(pl-pl,SQL.100).gif AlterXmlSchemaCollection  
ms220197.pubproperty(pl-pl,SQL.100).gif BindDefault  
ms220197.pubproperty(pl-pl,SQL.100).gif BindRule  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateApplicationRole  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateAssembly  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateAsymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateBrokerPriority  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif CreateContract  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateCredential  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateCryptographicProvider  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateDatabaseAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateDatabaseEncryptionKey  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateDefault  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif CreateEventNotification  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateEventSession  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateExtendedProcedure  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateExtendedProperty  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateFulltextCatalog  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateFulltextIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateFulltextStoplist  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateLinkedServer  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateLinkedServerLogin  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif CreateMasterKey  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateMessage  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateMessageType  
ms220197.pubproperty(pl-pl,SQL.100).gif CreatePartitionFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif CreatePartitionScheme  
ms220197.pubproperty(pl-pl,SQL.100).gif CreatePlanGuide  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateProcedure  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateQueue  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateRemoteServer  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateRemoteServiceBinding  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateResourcePool  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateRole  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateRoute  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateRule  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateSchema  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateServerAudit  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateServerAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateService  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateSpatialIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateStatistics  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateSymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateSynonym  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateTable  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateTrigger  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateType  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateUser  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateView  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateWorkloadGroup  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateXmlIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif CreateXmlSchemaCollection  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlAuthorizationServerEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlCredentialEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlCryptographicProviderEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlDatabaseEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlEndpointEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlEventSessionEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlExtendedProcedureEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlGdrServerEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlLinkedServerEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlLinkedServerLoginEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlLoginEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlMessageEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlRemoteServerEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlResourceGovernorEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlResourcePoolEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlServerAuditEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlServerAuditSpecificationEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlServerLevelEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlServerSecurityEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlServiceMasterKeyEventsEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DdlWorkloadGroupEvents  
ms220197.pubproperty(pl-pl,SQL.100).gif DenyDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif Dirty Gets or sets a Boolean property value that specifies whether the event set has been modified.
ms220197.pubproperty(pl-pl,SQL.100).gif DropApplicationRole  
ms220197.pubproperty(pl-pl,SQL.100).gif DropAssembly  
ms220197.pubproperty(pl-pl,SQL.100).gif DropAsymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif DropBrokerPriority  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif DropContract  
ms220197.pubproperty(pl-pl,SQL.100).gif DropCredential  
ms220197.pubproperty(pl-pl,SQL.100).gif DropCryptographicProvider  
ms220197.pubproperty(pl-pl,SQL.100).gif DropDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif DropDatabaseAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif DropDatabaseEncryptionKey  
ms220197.pubproperty(pl-pl,SQL.100).gif DropDefault  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif DropEventNotification  
ms220197.pubproperty(pl-pl,SQL.100).gif DropEventSession  
ms220197.pubproperty(pl-pl,SQL.100).gif DropExtendedProcedure  
ms220197.pubproperty(pl-pl,SQL.100).gif DropExtendedProperty  
ms220197.pubproperty(pl-pl,SQL.100).gif DropFulltextCatalog  
ms220197.pubproperty(pl-pl,SQL.100).gif DropFulltextIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif DropFulltextStoplist  
ms220197.pubproperty(pl-pl,SQL.100).gif DropFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif DropIndex  
ms220197.pubproperty(pl-pl,SQL.100).gif DropLinkedServer  
ms220197.pubproperty(pl-pl,SQL.100).gif DropLinkedServerLogin  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif DropMasterKey  
ms220197.pubproperty(pl-pl,SQL.100).gif DropMessage  
ms220197.pubproperty(pl-pl,SQL.100).gif DropMessageType  
ms220197.pubproperty(pl-pl,SQL.100).gif DropPartitionFunction  
ms220197.pubproperty(pl-pl,SQL.100).gif DropPartitionScheme  
ms220197.pubproperty(pl-pl,SQL.100).gif DropPlanGuide  
ms220197.pubproperty(pl-pl,SQL.100).gif DropProcedure  
ms220197.pubproperty(pl-pl,SQL.100).gif DropQueue  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRemoteServer  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRemoteServiceBinding  
ms220197.pubproperty(pl-pl,SQL.100).gif DropResourcePool  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRole  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRoleMember  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRoute  
ms220197.pubproperty(pl-pl,SQL.100).gif DropRule  
ms220197.pubproperty(pl-pl,SQL.100).gif DropSchema  
ms220197.pubproperty(pl-pl,SQL.100).gif DropServerAudit  
ms220197.pubproperty(pl-pl,SQL.100).gif DropServerAuditSpecification  
ms220197.pubproperty(pl-pl,SQL.100).gif DropServerRoleMember  
ms220197.pubproperty(pl-pl,SQL.100).gif DropService  
ms220197.pubproperty(pl-pl,SQL.100).gif DropSignature  
ms220197.pubproperty(pl-pl,SQL.100).gif DropSignatureSchemaObject  
ms220197.pubproperty(pl-pl,SQL.100).gif DropStatistics  
ms220197.pubproperty(pl-pl,SQL.100).gif DropSymmetricKey  
ms220197.pubproperty(pl-pl,SQL.100).gif DropSynonym  
ms220197.pubproperty(pl-pl,SQL.100).gif DropTable  
ms220197.pubproperty(pl-pl,SQL.100).gif DropTrigger  
ms220197.pubproperty(pl-pl,SQL.100).gif DropType  
ms220197.pubproperty(pl-pl,SQL.100).gif DropUser  
ms220197.pubproperty(pl-pl,SQL.100).gif DropView  
ms220197.pubproperty(pl-pl,SQL.100).gif DropWorkloadGroup  
ms220197.pubproperty(pl-pl,SQL.100).gif DropXmlSchemaCollection  
ms220197.pubproperty(pl-pl,SQL.100).gif GrantDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif Logon  
ms220197.pubproperty(pl-pl,SQL.100).gif NumberOfElements Overridden. Gets the number of events in the event set.
ms220197.pubproperty(pl-pl,SQL.100).gif Rename  
ms220197.pubproperty(pl-pl,SQL.100).gif RevokeDatabase  
ms220197.pubproperty(pl-pl,SQL.100).gif 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.
ms220197.pubproperty(pl-pl,SQL.100).gif UnbindDefault  
ms220197.pubproperty(pl-pl,SQL.100).gif UnbindRule  
ms220197.pubproperty(pl-pl,SQL.100).gif UpdateStatistics  

Top

Protected Properties

  Name Description
ms220197.protproperty(pl-pl,SQL.100).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220197.pubmethod(pl-pl,SQL.100).gif Add Overloaded. Returns a set of server DDL events after adding a new server DDL event to the set of events.
ms220197.pubmethod(pl-pl,SQL.100).gif Copy Overridden. Returns a copy of the event set.
ms220197.pubmethod(pl-pl,SQL.100).gif Equals  Overloaded. (inherited from Object )
ms220197.pubmethod(pl-pl,SQL.100).gif GetHashCode  (inherited from Object )
ms220197.pubmethod(pl-pl,SQL.100).gif GetType  (inherited from Object )
ms220197.pubmethod(pl-pl,SQL.100).gifms220197.static(pl-pl,SQL.100).gif op_Addition Creates a server data definition language (DDL) trigger event set by performing an addition operation on a ServerDdlTriggerEvent object and a ServerDdlTriggerEventSet object.
ms220197.pubmethod(pl-pl,SQL.100).gifms220197.static(pl-pl,SQL.100).gif op_Subtraction Creates a server data definition language (DDL) trigger event set by performing a subtraction operation on a ServerDdlTriggerEvent object and a ServerDdlTriggerEventSet object.
ms220197.pubmethod(pl-pl,SQL.100).gifms220197.static(pl-pl,SQL.100).gif ReferenceEquals  (inherited from Object )
ms220197.pubmethod(pl-pl,SQL.100).gif Remove Removes an event from the event set.
ms220197.pubmethod(pl-pl,SQL.100).gifms220197.static(pl-pl,SQL.100).gif Subtract Returns a set of server DDL trigger events after subtracting a DDL trigger event from the specified set of event set.
ms220197.pubmethod(pl-pl,SQL.100).gif ToString Overridden. Returns a string that represents the ServerDdlTriggerEventSet object.

Top

Protected Methods

  Name Description
ms220197.protmethod(pl-pl,SQL.100).gif Finalize  (inherited from Object )
ms220197.protmethod(pl-pl,SQL.100).gif FitsMask  (inherited from EventSetBase )
ms220197.protmethod(pl-pl,SQL.100).gif HasCommonBits  (inherited from EventSetBase )
ms220197.protmethod(pl-pl,SQL.100).gif MemberwiseClone  (inherited from Object )
ms220197.protmethod(pl-pl,SQL.100).gif SetValue  (inherited from EventSetBase )

Top

  • Last updated on