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.

Inheritance Hierarchy
Object
  Microsoft.SqlServer.Management.SmoServerDdlTriggerEvent

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
Syntax
Public NotInheritable Class ServerDdlTriggerEvent
Dim instance As ServerDdlTriggerEvent
public sealed class ServerDdlTriggerEvent
public ref class ServerDdlTriggerEvent sealed
[<SealedAttribute>]
type ServerDdlTriggerEvent =  class end
public final class ServerDdlTriggerEvent

The ServerDdlTriggerEvent type exposes the following members.

Properties
  NameDescription
Public property Static member AddRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AddServerRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AddSignatureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AddSignatureSchemaObjectGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterAuthorizationDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterAuthorizationServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterAvailabilityGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterCertificateGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterEndpointGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterInstanceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterPartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterPartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterPlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterResourceGovernorConfigGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterSearchPropertyListGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterSequenceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterServerRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterServiceMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member AlterXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member BindDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member BindRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateAvailabilityGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateCertificateGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateContractGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateEndpointGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateEventNotificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateExtendedProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateLinkedServerLoginGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreatePartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreatePartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreatePlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSearchPropertyListGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSequenceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateServerRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSpatialIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateSynonymGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateXmlIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member CreateXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DenyDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DenyServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropApplicationRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropAssemblyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropAsymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropAvailabilityGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropBrokerPriorityGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropCertificateGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropContractGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropCredentialGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropCryptographicProviderGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropDatabaseAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropDatabaseEncryptionKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropEndpointGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropEventNotificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropEventSessionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropExtendedProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropExtendedPropertyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropFulltextCatalogGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropFulltextIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropFulltextStoplistGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropIndexGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropLinkedServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropLinkedServerLoginGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropLoginGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropMasterKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropMessageGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropMessageTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropPartitionFunctionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropPartitionSchemeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropPlanGuideGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropProcedureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropQueueGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRemoteServerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRemoteServiceBindingGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropResourcePoolGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRouteGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSchemaGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSearchPropertyListGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSequenceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropServerAuditGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropServerAuditSpecificationGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropServerRoleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropServerRoleMemberGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropServiceGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSignatureGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSignatureSchemaObjectGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSymmetricKeyGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropSynonymGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropTableGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropTriggerGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropTypeGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropUserGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropViewGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropWorkloadGroupGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member DropXmlSchemaCollectionGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member GrantDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member GrantServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member LogonGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member RenameGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member RevokeDatabaseGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member RevokeServerGets a server data definition language (DDL) trigger event that can be included in the event set.
Public property Static member UnbindDefaultGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member UnbindRuleGets a database data definition language (DDL) trigger event that can be included in the event set.
Public property Static member UpdateStatisticsGets a database data definition language (DDL) trigger event that can be included in the event set.
Top
Methods
  NameDescription
Public method Static member AddReturns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set.
Public method Static member BitwiseOrCreates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects.
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public method ToStringReturns the object in String format. (Overrides Object.ToString.)
Top
Operators
  NameDescription
Public operator Static member AdditionCreates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects.
Public operator Static member BitwiseOrCreates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects.
Public operator Static member (ServerDdlTriggerEvent to ServerDdlTriggerEventSet)Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object.
Top
Remarks

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.

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.