DatabaseEventSet Class

The DatabaseEventSet object represents a SQL Server set of database events.

Inheritance Hierarchy

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

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

Syntax

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

public sealed class DatabaseEventSet : EventSetBase

public ref class DatabaseEventSet sealed : public EventSetBase

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

public final class DatabaseEventSet extends EventSetBase

The DatabaseEventSet type exposes the following members.

Constructors

	Name	Description
	DatabaseEventSet()	Initializes a new instance of the DatabaseEventSet class.
	DatabaseEventSet(DatabaseEvent)	Initializes a new instance of the DatabaseEventSet class with a specified set of events.
	DatabaseEventSet(array<DatabaseEvent[])	Initializes a new instance of the DatabaseEventSet class with a specified set of events.
	DatabaseEventSet(DatabaseEventSet)	Initializes a new instance of the DatabaseEventSet class with a specified set of events.

Top

Properties

	Name	Description
	AddRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is added to a database role in the database.
	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 in the database.
	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 in the database.
	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 the 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. The event occurs when a certificate is altered in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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. The event occurs when a certificate is created in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access the database is denied.
	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 from the database.
	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 from the database.
	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. The event occurs when a certificate is dropped from the database.
	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 from the database.
	DropDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database 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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	DropQueue	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 dropped from the database.
	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 from the database.
	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 from the database.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is dropped from a database role in the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 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 to the database is revoked.
	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 the statistics are updated in the database.

Top

Methods

	Name	Description
	Add(DatabaseEvent)	Returns a set of database events after adding a new database event to the referenced event set.
	Add(DatabaseEventSet, DatabaseEvent)	Returns a set of database events after adding a new database event to the specified event set.
	Copy	Returns a copy of the DatabaseEventSet object. (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 events after removing a database event from the specified event set.
	ToString	Returns a string that represents the DatabaseEventSet object. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
	Subtraction	Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.

Top

Remarks

The DatabaseEventSet object is required to specify the set of events that apply to the events that are generated by the database.

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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace