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
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.

Top

Methods

	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.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	Returns the object in String format. (Overrides Object.ToString().)

Top

Operators

	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.

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