共用方式為


ServerDdlTriggerEventSet Members

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

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

Public Constructors

  名稱 Description
ServerDdlTriggerEventSet Overloaded. Initializes a new instance of the ServerDdlTriggerEventSet class.

頂端

Public Properties

(see also Protected Properties )

  名稱 Description
ms220197.pubproperty(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).gif DdlAuthorizationServerEvents Gets or sets a Boolean property value that specifies whether data definition language (DDL) authorization server events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlCertificateEvents Gets or sets a Boolean property value that specifies whether data definition language (DDL) certificate events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlEndpointEvents Gets or sets a Boolean property value that specifies whether data definition language (DDL) HTTP endpoint events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlGdrServerEvents Gets or sets a Boolean property value that specifies whether data definition language (DDL) GDR server events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlLoginEvents Gets or sets a Boolean property value that specifies whether data definition language (DDL) login events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlServerLevelEvents Gets or sets a Boolean property value that specifies whether DDL server level events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).gif DdlServerSecurityEvents Gets or sets a Boolean property value that specifies whether DDL server security events are included in the event set.
ms220197.pubproperty(zh-tw,SQL.90).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(zh-tw,SQL.90).gif Dirty Gets or sets a Boolean property value that specifies whether the event set has been modified.
ms220197.pubproperty(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).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(zh-tw,SQL.90).gif NumberOfElements Overridden. Gets the number of events in the event set.
ms220197.pubproperty(zh-tw,SQL.90).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.

頂端

Protected Properties

  名稱 Description
ms220197.protproperty(zh-tw,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

頂端

Public Methods

(see also Protected Methods )

  名稱 Description
ms220197.pubmethod(zh-tw,SQL.90).gif Add Overloaded. Returns a set of server DDL events after adding a new server DDL event to the set of events.
ms220197.pubmethod(zh-tw,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms220197.pubmethod(zh-tw,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220197.pubmethod(zh-tw,SQL.90).gif GetHashCode  (inherited from Object )
ms220197.pubmethod(zh-tw,SQL.90).gif GetType  (inherited from Object )
ms220197.pubmethod(zh-tw,SQL.90).gifms220197.static(zh-tw,SQL.90).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(zh-tw,SQL.90).gifms220197.static(zh-tw,SQL.90).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(zh-tw,SQL.90).gifms220197.static(zh-tw,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220197.pubmethod(zh-tw,SQL.90).gif Remove Removes an event from the event set.
ms220197.pubmethod(zh-tw,SQL.90).gifms220197.static(zh-tw,SQL.90).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(zh-tw,SQL.90).gif ToString Overridden. Returns a string that represents the ServerDdlTriggerEventSet object.

頂端

Protected Methods

  名稱 Description
ms220197.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms220197.protmethod(zh-tw,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms220197.protmethod(zh-tw,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms220197.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220197.protmethod(zh-tw,SQL.90).gif SetValue  (inherited from EventSetBase )

頂端

請參閱

參考

ServerDdlTriggerEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Handling SMO Events
與 DDL 觸發程序搭配使用的事件群組