• Article

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
Public method DatabaseEventSet() Initializes a new instance of the DatabaseEventSet class.
Public method DatabaseEventSet(DatabaseEvent) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Public method DatabaseEventSet(array<DatabaseEvent[]) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Public method DatabaseEventSet(DatabaseEventSet) Initializes a new instance of the DatabaseEventSet class with a specified set of events.

Top

Properties

  Name Description
Public property 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.
Public property AddSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AddSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property AlterMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property AlterPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property AlterSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property BindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property BindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property CreateDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property CreateMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property CreatePlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property CreateRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DropAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DropDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property DropMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property DropPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DropRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DropSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property NumberOfElements Gets the number of events included in the event set. (Overrides EventSetBase.NumberOfElements.)
Public property Rename Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public property UnbindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property UnbindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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
Public method Add(DatabaseEvent) Returns a set of database events after adding a new database event to the referenced event set.
Public methodStatic member Add(DatabaseEventSet, DatabaseEvent) Returns a set of database events after adding a new database event to the specified event set.
Public method Copy Returns a copy of the DatabaseEventSet object. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Protected method FitsMask Specifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method HasCommonBits Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Remove Removes an event from the event set.
Protected method SetValue Sets the bit value at the specified index position. (Inherited from EventSetBase.)
Public methodStatic member Subtract Returns a set of database events after removing a database event from the specified event set.
Public method ToString Returns a string that represents the DatabaseEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
Public operatorStatic member 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.

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.