DatabaseEventSet Class

 

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

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

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

No code example is currently available or this language may not be supported.

NameDescription
System_CAPS_pubmethodDatabaseEventSet()

Initializes a new instance of the DatabaseEventSet class.

System_CAPS_pubmethodDatabaseEventSet(DatabaseEvent)

Initializes a new instance of the DatabaseEventSet class with a specified set of events.

System_CAPS_pubmethodDatabaseEventSet(DatabaseEvent[])

Initializes a new instance of the DatabaseEventSet class with a specified set of events.

System_CAPS_pubmethodDatabaseEventSet(DatabaseEventSet)

Initializes a new instance of the DatabaseEventSet class with a specified set of events.

NameDescription
System_CAPS_pubpropertyAddRoleMember

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.

System_CAPS_pubpropertyAddSignature

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAddSignatureSchemaObject

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterApplicationRole

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.

System_CAPS_pubpropertyAlterAssembly

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.

System_CAPS_pubpropertyAlterAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterAuthorizationDatabase

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.

System_CAPS_pubpropertyAlterBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterCertificate

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.

System_CAPS_pubpropertyAlterColumnEncryptionKey

Gets or sets a value that indicates whether the database alters column encryption key.

System_CAPS_pubpropertyAlterDatabaseAuditSpecification

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.

System_CAPS_pubpropertyAlterDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterFulltextStoplist

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.

System_CAPS_pubpropertyAlterFunction

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.

System_CAPS_pubpropertyAlterIndex

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.

System_CAPS_pubpropertyAlterMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterMessageType

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.

System_CAPS_pubpropertyAlterPartitionFunction

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.

System_CAPS_pubpropertyAlterPartitionScheme

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.

System_CAPS_pubpropertyAlterPlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterProcedure

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.

System_CAPS_pubpropertyAlterQueue

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.

System_CAPS_pubpropertyAlterRemoteServiceBinding

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.

System_CAPS_pubpropertyAlterRole

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.

System_CAPS_pubpropertyAlterRoute

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.

System_CAPS_pubpropertyAlterSchema

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.

System_CAPS_pubpropertyAlterSearchPropertyList

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.

System_CAPS_pubpropertyAlterSecurityPolicy

Gets or sets a value that indicates whether to alter security policy.

System_CAPS_pubpropertyAlterSequence

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.

System_CAPS_pubpropertyAlterService

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.

System_CAPS_pubpropertyAlterSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAlterTable

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.

System_CAPS_pubpropertyAlterTrigger

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.

System_CAPS_pubpropertyAlterUser

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.

System_CAPS_pubpropertyAlterView

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.

System_CAPS_pubpropertyAlterXmlSchemaCollection

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.

System_CAPS_pubpropertyBindDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyBindRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateApplicationRole

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.

System_CAPS_pubpropertyCreateAssembly

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.

System_CAPS_pubpropertyCreateAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateCertificate

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.

System_CAPS_pubpropertyCreateColumnEncryptionKey

Gets or sets a value that specifies whether the CreateColumnEncryptionKey is included in the event set.

System_CAPS_pubpropertyCreateColumnMasterKey

Gets or sets the master key to create column.

System_CAPS_pubpropertyCreateContract

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.

System_CAPS_pubpropertyCreateDatabaseAuditSpecification

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.

System_CAPS_pubpropertyCreateDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateEventNotification

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.

System_CAPS_pubpropertyCreateExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateFulltextStoplist

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.

System_CAPS_pubpropertyCreateFunction

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.

System_CAPS_pubpropertyCreateIndex

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.

System_CAPS_pubpropertyCreateMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateMessageType

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.

System_CAPS_pubpropertyCreatePartitionFunction

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.

System_CAPS_pubpropertyCreatePartitionScheme

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.

System_CAPS_pubpropertyCreatePlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateProcedure

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.

System_CAPS_pubpropertyCreateQueue

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.

System_CAPS_pubpropertyCreateRemoteServiceBinding

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.

System_CAPS_pubpropertyCreateRole

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.

System_CAPS_pubpropertyCreateRoute

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.

System_CAPS_pubpropertyCreateRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateSchema

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.

System_CAPS_pubpropertyCreateSearchPropertyList

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.

System_CAPS_pubpropertyCreateSecurityPolicy

Gets or sets a value that indicates whether the CreateSecurityPolicy is included in the event set.

System_CAPS_pubpropertyCreateSequence

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.

System_CAPS_pubpropertyCreateService

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.

System_CAPS_pubpropertyCreateSpatialIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateStatistics

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.

System_CAPS_pubpropertyCreateSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyCreateSynonym

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.

System_CAPS_pubpropertyCreateTable

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.

System_CAPS_pubpropertyCreateTrigger

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.

System_CAPS_pubpropertyCreateType

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.

System_CAPS_pubpropertyCreateUser

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.

System_CAPS_pubpropertyCreateView

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.

System_CAPS_pubpropertyCreateXmlIndex

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.

System_CAPS_pubpropertyCreateXmlSchemaCollection

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.

System_CAPS_pubpropertyDenyDatabase

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.

System_CAPS_pubpropertyDropApplicationRole

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.

System_CAPS_pubpropertyDropAssembly

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.

System_CAPS_pubpropertyDropAsymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropBrokerPriority

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropCertificate

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.

System_CAPS_pubpropertyDropColumnEncryptionKey

Gets or sets a value that indicates whether the database drops column encryption key.

System_CAPS_pubpropertyDropColumnMasterKey

Gets or sets a value that indicates whether the database drops column master key.

System_CAPS_pubpropertyDropContract

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.

System_CAPS_pubpropertyDropDatabase

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.

System_CAPS_pubpropertyDropDatabaseAuditSpecification

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.

System_CAPS_pubpropertyDropDatabaseEncryptionKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropEventNotification

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.

System_CAPS_pubpropertyDropExtendedProperty

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextCatalog

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextIndex

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropFulltextStoplist

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.

System_CAPS_pubpropertyDropFunction

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.

System_CAPS_pubpropertyDropIndex

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.

System_CAPS_pubpropertyDropMasterKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropMessageType

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.

System_CAPS_pubpropertyDropPartitionFunction

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.

System_CAPS_pubpropertyDropPartitionScheme

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.

System_CAPS_pubpropertyDropPlanGuide

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropProcedure

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.

System_CAPS_pubpropertyDropQueue

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.

System_CAPS_pubpropertyDropRemoteServiceBinding

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.

System_CAPS_pubpropertyDropRole

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.

System_CAPS_pubpropertyDropRoleMember

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.

System_CAPS_pubpropertyDropRoute

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.

System_CAPS_pubpropertyDropRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSchema

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.

System_CAPS_pubpropertyDropSearchPropertyList

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.

System_CAPS_pubpropertyDropSecurityPolicy

Gets or sets a value that specifies whether the DropSecurityPolicy is included in the event set.

System_CAPS_pubpropertyDropSequence

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.

System_CAPS_pubpropertyDropService

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.

System_CAPS_pubpropertyDropSignature

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSignatureSchemaObject

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropStatistics

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.

System_CAPS_pubpropertyDropSymmetricKey

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDropSynonym

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.

System_CAPS_pubpropertyDropTable

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.

System_CAPS_pubpropertyDropTrigger

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.

System_CAPS_pubpropertyDropType

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.

System_CAPS_pubpropertyDropUser

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.

System_CAPS_pubpropertyDropView

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.

System_CAPS_pubpropertyDropXmlSchemaCollection

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.

System_CAPS_pubpropertyGrantDatabase

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.

System_CAPS_pubpropertyNumberOfElements

Gets the number of events included in the event set.(Overrides EventSetBase.NumberOfElements.)

System_CAPS_pubpropertyRename

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyRevokeDatabase

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.

System_CAPS_protpropertyStorage

Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

System_CAPS_pubpropertyUnbindDefault

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyUnbindRule

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyUpdateStatistics

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.

NameDescription
System_CAPS_pubmethodAdd(DatabaseEvent)

Returns a set of database events after adding a new database event to the referenced event set.

System_CAPS_pubmethodSystem_CAPS_staticAdd(DatabaseEventSet, DatabaseEvent)

Returns a set of database events after adding a new database event to the specified event set.

System_CAPS_pubmethodCopy()

Returns a copy of the DatabaseEventSet object.(Overrides EventSetBase.Copy().)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(DatabaseEvent)

Removes an event from the event set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(DatabaseEventSet, DatabaseEvent)

Returns a set of database events after removing a database event from the specified event set.

System_CAPS_pubmethodToString()

Returns a string that represents the DatabaseEventSet object.(Overrides Object.ToString().)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(DatabaseEventSet, DatabaseEvent)

Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(DatabaseEventSet, DatabaseEvent)

Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.

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

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.

Return to top
Show: