Article
02/08/2012

DatabaseDdlTriggerEventSet Class

The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Management.Smo.EventSetBase
Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerEventSet

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

Syntax

'Declaration
Public NotInheritable Class DatabaseDdlTriggerEventSet _
    Inherits EventSetBase
'Usage
Dim instance As DatabaseDdlTriggerEventSet

public sealed class DatabaseDdlTriggerEventSet : EventSetBase

public ref class DatabaseDdlTriggerEventSet sealed : public EventSetBase

[<SealedAttribute>]
type DatabaseDdlTriggerEventSet =  
    class
        inherit EventSetBase
    end

public final class DatabaseDdlTriggerEventSet extends EventSetBase

The DatabaseDdlTriggerEventSet type exposes the following members.

Constructors

	Name	Description
	DatabaseDdlTriggerEventSet()	Initializes a new instance of the DatabaseDdlTriggerEventSet class.
	DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent)	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
	DatabaseDdlTriggerEventSet(array<DatabaseDdlTriggerEvent[])	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
	DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEventSet)	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

Top

Properties

	Name	Description
	AddRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AddSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AddSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered.
	AlterAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered.
	AlterAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterAuthorizationDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization database is altered.
	AlterBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
	AlterDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is altered.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered.
	AlterIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered.
	AlterMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered.
	AlterPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered.
	AlterPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered.
	AlterPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered.
	AlterQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered.
	AlterRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered.
	AlterRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered.
	AlterSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered.
	AlterService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered.
	AlterSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered.
	AlterTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered.
	AlterView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered.
	AlterXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered.
	BindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	BindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created.
	CreateAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created.
	CreateAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created.
	CreateDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created.
	CreateDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created.
	CreateExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is created.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created.
	CreateIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created.
	CreateMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created.
	CreatePartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created.
	CreatePartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created.
	CreatePlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is created.
	CreateQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created.
	CreateRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created.
	CreateRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created.
	CreateRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created.
	CreateService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created.
	CreateSpatialIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is created.
	CreateSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created.
	CreateTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created.
	CreateTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created.
	CreateType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created.
	CreateView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created.
	CreateXmlIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created.
	CreateXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created.
	DdlApplicationRoleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAssemblyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAsymmetricKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAuthorizationDatabaseEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlBrokerPriorityEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlCertificateEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlContractEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlCryptoSignatureEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseAuditSpecificationEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseEncryptionKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseLevelEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseSecurityEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDefaultEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlEventNotificationEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlExtendedPropertyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFulltextCatalogEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFulltextStoplistEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFunctionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlGdrDatabaseEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlIndexEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlMasterKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlMessageTypeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionFunctionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionSchemeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPlanGuideEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlProcedureEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlQueueEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRemoteServiceBindingEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRoleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRouteEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRuleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSchemaEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlServiceEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSsbEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlStatisticsEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSymmetricKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSynonymEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTableEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTableViewEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTriggerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTypeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlUserEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlViewEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlXmlSchemaCollectionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether events are included in the event set.
	Dirty	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when data stored in the cache needs refreshing is encountered.
	DropApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped.
	DropAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped.
	DropAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped.
	DropDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
	DropDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped.
	DropExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is dropped.
	DropFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped.
	DropIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped.
	DropMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped.
	DropPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped.
	DropPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped.
	DropPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped.
	DropQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Service Broker queue is dropped.
	DropRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped.
	DropRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped.
	DropService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped.
	DropSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped.
	DropSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped.
	DropTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped.
	DropTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped.
	DropType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped.
	DropView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped.
	DropXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
	NumberOfElements	Gets the number of events that are included in the event set. (Overrides EventSetBase.NumberOfElements.)
	Rename	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	RevokeDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is revoked from the database.
	Storage	Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
	UnbindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UnbindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when statistics are updated.

Top

Methods

	Name	Description
	Add(DatabaseDdlTriggerEvent)	Returns a set of database DDL trigger events after adding a new event to the event referenced set.
	Add(DatabaseDdlTriggerEventSet, DatabaseDdlTriggerEvent)	Returns a set of database DDL trigger events after adding a new event to the event specified set.
	Copy	Returns a copy of the event set. (Overrides EventSetBase.Copy().)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	FitsMask	Specifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	HasCommonBits	Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
	MemberwiseClone	(Inherited from Object.)
	Remove	Removes an event from the event set.
	SetValue	Sets the bit value at the specified index position. (Inherited from EventSetBase.)
	Subtract	Returns a set of database DDL trigger events after removing an event from the event specified set.
	ToString	Returns a string that represents the DatabaseDdlTriggerEventSet object. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
	Subtraction	Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.

Top

Remarks

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The DatabaseDdlTriggerEventSet object contains a property for each event to which the database DDL trigger responds.

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.

Examples

Handling SMO Events

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.

Share via

DatabaseDdlTriggerEventSet Class

Inheritance Hierarchy

Syntax

Constructors

Properties

Methods

Operators

Remarks

Thread Safety

Examples

Thread Safety

See Also

Reference

Additional resources