ServerDdlTriggerEvent Class
SQL Server 2012
The ServerDdlTriggerEvent object represents the Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
The ServerDdlTriggerEvent type exposes the following members.
| Name | Description | |
|---|---|---|
 | AddRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AddServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AddSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AddSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterAuthorizationDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterAuthorizationServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| AlterAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterCertificate | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| AlterCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| AlterEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterInstance | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| AlterMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterResourceGovernorConfig | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterServiceMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| AlterXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| BindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| BindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| CreateEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| CreateMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreatePartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreatePartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreatePlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSpatialIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateXmlIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| CreateXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DenyDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DenyServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| DropApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropEndpoint | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| DropMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| DropXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| GrantDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| GrantServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| Logon | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| Rename | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| RevokeDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| RevokeServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
| UnbindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| UnbindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| UpdateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| Name | Description | |
|---|---|---|
| Add | Returns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set. |
| BitwiseOr | Creates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects. |
| Equals | (Inherited from Object.) |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| ToString | Returns the object in String format. (Overrides Object.ToString().) |
| Name | Description | |
|---|---|---|
| Addition | Creates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects. |
| BitwiseOr | Creates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects. |
| Implicit(ServerDdlTriggerEvent to ServerDdlTriggerEventSet) | Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object. |
DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The ServerDdlTriggerEvent object contains a property for each event to which the server DDL trigger can respond. The actual set of events is specified using the ServerDdlTriggerEventSet object.
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.
