Classe DatabaseEventSet

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

Hierarquia de herança

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

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

Sintaxe

'Declaração
Public NotInheritable Class DatabaseEventSet _
    Inherits EventSetBase
'Uso
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

O tipo DatabaseEventSet expõe os membros a seguir.

Construtores

	Nome	Descrição
	DatabaseEventSet()	Initializes a new instance of the DatabaseEventSet class.
	DatabaseEventSet(DatabaseEvent)	Initializes a new instance of the DatabaseEventSet class with a specified set of events.
	DatabaseEventSet(array<DatabaseEvent[])	Initializes a new instance of the DatabaseEventSet class with a specified set of events.
	DatabaseEventSet(DatabaseEventSet)	Initializes a new instance of the DatabaseEventSet class with a specified set of events.

Início

Propriedades

	Nome	Descrição
	AddRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is added to a database role in the database.
	AddSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AddSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered in the database.
	AlterAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered in the database.
	AlterAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterAuthorizationDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the authorization database is altered.
	AlterBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is altered in the database.
	AlterDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
	AlterDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is altered in the database.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered in the database.
	AlterIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered in the database.
	AlterMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered in the database.
	AlterPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered in the database.
	AlterPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered in the database.
	AlterPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered in the database.
	AlterQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered in the database.
	AlterRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered in the database.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered in the database.
	AlterRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered in the database.
	AlterSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered in the database.
	AlterSearchPropertyList	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.
	AlterSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered in the database.
	AlterService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered in the database.
	AlterSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered in the database.
	AlterTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered in the database.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered in the database.
	AlterView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered in the database.
	AlterXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered in the database.
	BindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	BindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created in the database.
	CreateAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created in the database.
	CreateAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is created in the database.
	CreateContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created in the database.
	CreateDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created in the database.
	CreateDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created in the database.
	CreateExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is created in the database.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created in the database.
	CreateIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created in the database.
	CreateMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created in the database.
	CreatePartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created in the database.
	CreatePartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created in the database.
	CreatePlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is created in the database.
	CreateQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created in the database.
	CreateRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created in the database.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created in the database.
	CreateRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created in the database.
	CreateRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created in the database.
	CreateSearchPropertyList	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.
	CreateSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created in the database.
	CreateService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created in the database.
	CreateSpatialIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is created in the database.
	CreateSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created in the database.
	CreateTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created in the database.
	CreateTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created in the database.
	CreateType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created in the database.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created in the database.
	CreateView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created in the database.
	CreateXmlIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created in the database.
	CreateXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created in the database.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access the database is denied.
	DropApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped from the database.
	DropAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped from the database.
	DropAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is dropped from the database.
	DropContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped from the database.
	DropDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database is dropped.
	DropDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
	DropDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped from the database.
	DropExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is dropped from the database.
	DropFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped from the database.
	DropIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped from the database.
	DropMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped from the database.
	DropPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped from the database.
	DropPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped from the database.
	DropPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped from the database.
	DropQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is dropped from the database.
	DropRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped from the database.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped from the database.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is dropped from a database role in the database.
	DropRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped from the database.
	DropRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped from the database.
	DropSearchPropertyList	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.
	DropSequence	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped from the database.
	DropService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped from the database.
	DropSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped from the database.
	DropSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped from the database.
	DropTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped from the database.
	DropTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped from the database.
	DropType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped from the database.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped from the database.
	DropView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped from the database.
	DropXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped from the database.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
	NumberOfElements	Gets the number of events included in the event set. (Substitui EventSetBase.NumberOfElements.)
	Rename	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	RevokeDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access to the database is revoked.
	Storage	Gets or sets the bit array for event set storage. (Herdado de EventSetBase.)
	UnbindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UnbindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the statistics are updated in the database.

Início

Métodos

	Nome	Descrição
	Add(DatabaseEvent)	Returns a set of database events after adding a new database event to the referenced event set.
	Add(DatabaseEventSet, DatabaseEvent)	Returns a set of database events after adding a new database event to the specified event set.
	Copy	Returns a copy of the DatabaseEventSet object. (Substitui EventSetBase.Copy().)
	Equals	(Herdado de Object.)
	GetHashCode	(Herdado de Object.)
	GetType	(Herdado de Object.)
	Remove	Removes an event from the event set.
	Subtract	Returns a set of database events after removing a database event from the specified event set.
	ToString	Returns a string that represents the DatabaseEventSet object. (Substitui Object.ToString().)

Início

Operadores

	Nome	Descrição
	Addition	Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
	Subtraction	Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.

Início

Comentários

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

Thread Safety

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Manipulando eventos SMO

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo