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

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

Syntax

'Declaration
Public NotInheritable Class ServerDdlTriggerEvent
'Usage
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

  Name Description
Public propertyStatic member AddRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AddServerRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AddSignature Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AddSignatureSchemaObject Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterAuthorizationDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterAuthorizationServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterAvailabilityGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterCertificate Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterEndpoint Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterInstance Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterPartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterPartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterPlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterResourceGovernorConfig Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterSearchPropertyList Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterSequence Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterServerRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterServiceMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member AlterXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member BindDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member BindRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateAvailabilityGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateCertificate Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateContract Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateEndpoint Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateEventNotification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateExtendedProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateLinkedServerLogin Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreatePartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreatePartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreatePlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSearchPropertyList Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSequence Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateServerRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSpatialIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateSynonym Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateXmlIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member CreateXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DenyDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DenyServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropAvailabilityGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropCertificate Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropContract Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropEndpoint Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropEventNotification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropExtendedProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropLinkedServerLogin Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropPartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropPartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropPlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSearchPropertyList Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSequence Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropServerRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropServerRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSignature Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSignatureSchemaObject Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropSynonym Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member DropXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member GrantDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member GrantServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member Logon Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member Rename Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member RevokeDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member RevokeServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member UnbindDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member UnbindRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Public propertyStatic member UpdateStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.

Top

Methods

  Name Description
Public methodStatic member Add Returns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set.
Public methodStatic member BitwiseOr Creates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects.
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method ToString Returns the object in String format. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects.
Public operatorStatic member BitwiseOr Creates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects.
Public operatorStatic member Implicit(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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events