Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

DatabaseEventSet Properties

 

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

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_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_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_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_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_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_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.

Return to top
Show:
© 2016 Microsoft