Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DatabaseEventSet Class

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

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)
[<SealedAttribute>]
type DatabaseEventSet =  
    class 
        inherit EventSetBase 
    end

The DatabaseEventSet type exposes the following members.

  NameDescription
Public methodDatabaseEventSet()Initializes a new instance of the DatabaseEventSet class.
Public methodDatabaseEventSet(DatabaseEvent)Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Public methodDatabaseEventSet(DatabaseEvent[])Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Public methodDatabaseEventSet(DatabaseEventSet)Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Top
  NameDescription
Public propertyAddRoleMemberGets 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 propertyAddSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAddSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterApplicationRoleGets 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 propertyAlterAssemblyGets 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 propertyAlterAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterAuthorizationDatabaseGets 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 propertyAlterBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterCertificateGets 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 propertyAlterDatabaseAuditSpecificationGets 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 propertyAlterDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextStoplistGets 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 propertyAlterFunctionGets 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 propertyAlterIndexGets 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 propertyAlterMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterMessageTypeGets 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 propertyAlterPartitionFunctionGets 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 propertyAlterPartitionSchemeGets 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 propertyAlterPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterProcedureGets 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 propertyAlterQueueGets 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 propertyAlterRemoteServiceBindingGets 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 propertyAlterRoleGets 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 propertyAlterRouteGets 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 propertyAlterSchemaGets 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 propertyAlterSearchPropertyListGets 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 propertyAlterSequenceGets 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 propertyAlterServiceGets 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 propertyAlterSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterTableGets 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 propertyAlterTriggerGets 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 propertyAlterUserGets 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 propertyAlterViewGets 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 propertyAlterXmlSchemaCollectionGets 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 propertyBindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyBindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateApplicationRoleGets 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 propertyCreateAssemblyGets 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 propertyCreateAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateCertificateGets 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 propertyCreateContractGets 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 propertyCreateDatabaseAuditSpecificationGets 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 propertyCreateDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateEventNotificationGets 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 propertyCreateExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextStoplistGets 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 propertyCreateFunctionGets 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 propertyCreateIndexGets 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 propertyCreateMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateMessageTypeGets 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 propertyCreatePartitionFunctionGets 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 propertyCreatePartitionSchemeGets 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 propertyCreatePlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateProcedureGets 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 propertyCreateQueueGets 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 propertyCreateRemoteServiceBindingGets 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 propertyCreateRoleGets 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 propertyCreateRouteGets 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 propertyCreateRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSchemaGets 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 propertyCreateSearchPropertyListGets 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 propertyCreateSequenceGets 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 propertyCreateServiceGets 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 propertyCreateSpatialIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateStatisticsGets 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 propertyCreateSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSynonymGets 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 propertyCreateTableGets 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 propertyCreateTriggerGets 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 propertyCreateTypeGets 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 propertyCreateUserGets 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 propertyCreateViewGets 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 propertyCreateXmlIndexGets 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 propertyCreateXmlSchemaCollectionGets 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 propertyDenyDatabaseGets 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 propertyDropApplicationRoleGets 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 propertyDropAssemblyGets 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 propertyDropAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropCertificateGets 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 propertyDropContractGets 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 propertyDropDatabaseGets 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 propertyDropDatabaseAuditSpecificationGets 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 propertyDropDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropEventNotificationGets 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 propertyDropExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextStoplistGets 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 propertyDropFunctionGets 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 propertyDropIndexGets 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 propertyDropMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropMessageTypeGets 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 propertyDropPartitionFunctionGets 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 propertyDropPartitionSchemeGets 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 propertyDropPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropProcedureGets 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 propertyDropQueueGets 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 propertyDropRemoteServiceBindingGets 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 propertyDropRoleGets 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 propertyDropRoleMemberGets 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 propertyDropRouteGets 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 propertyDropRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSchemaGets 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 propertyDropSearchPropertyListGets 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 propertyDropSequenceGets 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 propertyDropServiceGets 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 propertyDropSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropStatisticsGets 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 propertyDropSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSynonymGets 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 propertyDropTableGets 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 propertyDropTriggerGets 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 propertyDropTypeGets 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 propertyDropUserGets 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 propertyDropViewGets 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 propertyDropXmlSchemaCollectionGets 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 propertyGrantDatabaseGets 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 propertyNumberOfElementsGets the number of events included in the event set. (Overrides EventSetBase.NumberOfElements.)
Public propertyRenameGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyRevokeDatabaseGets 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 propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public propertyUnbindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUnbindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUpdateStatisticsGets 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
  NameDescription
Public methodAdd(DatabaseEvent)Returns a set of database events after adding a new database event to the referenced event set.
Public methodStatic memberAdd(DatabaseEventSet, DatabaseEvent)Returns a set of database events after adding a new database event to the specified event set.
Public methodCopyReturns a copy of the DatabaseEventSet object. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Public methodStatic memberSubtractReturns a set of database events after removing a database event from the specified event set.
Public methodToStringReturns a string that represents the DatabaseEventSet object. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
Public operatorStatic memberSubtractionCreates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.