Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ServerDdlTriggerEvent Class

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.

System.Object
  Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEvent

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
public sealed class ServerDdlTriggerEvent

The ServerDdlTriggerEvent type exposes the following members.

  NameDescription
Public propertyStatic memberAddRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAddServerRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAddSignatureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAddSignatureSchemaObjectGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterAuthorizationDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterAuthorizationServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterCertificateGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterEndpointGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterInstanceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterPartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterPartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterPlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterResourceGovernorConfigGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterServiceMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberAlterXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberBindDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberBindRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateCertificateGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateContractGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateEndpointGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateEventNotificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateExtendedProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateLinkedServerLoginGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreatePartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreatePartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreatePlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateSpatialIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateSynonymGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateXmlIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberCreateXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDenyDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDenyServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropCertificateGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropContractGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropEndpointGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropEventNotificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropExtendedProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropLinkedServerLoginGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropPartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropPartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropPlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropServerRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropSignatureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropSignatureSchemaObjectGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropSynonymGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberDropXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberGrantDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberGrantServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberLogonGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberRenameGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberRevokeDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberRevokeServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberUnbindDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberUnbindRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic memberUpdateStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Top
  NameDescription
Public methodStatic memberAddReturns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set.
Public methodStatic memberBitwiseOrCreates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToStringReturns the object in String format. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects.
Public operatorStatic memberBitwiseOrCreates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects.
Public operatorStatic memberImplicit(ServerDdlTriggerEvent to ServerDdlTriggerEventSet)Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.