Classe ServerEventSet

The ServerEventSet object represents a set of server events on an instance of SQL Server.

Hierarquia de herança

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .EventSetBase
    Microsoft.SqlServer.Management.Smo..::..ServerEventSet

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

Sintaxe

'Declaração
Public NotInheritable Class ServerEventSet _
    Inherits EventSetBase
'Uso
Dim instance As ServerEventSet

public sealed class ServerEventSet : EventSetBase

public ref class ServerEventSet sealed : public EventSetBase

[<SealedAttribute>]
type ServerEventSet =  
    class
        inherit EventSetBase
    end

public final class ServerEventSet extends EventSetBase

O tipo ServerEventSet expõe os membros a seguir.

Construtores

	Nome	Descrição
	ServerEventSet() () () ()	Initializes a new instance of the ServerEventSet class.
	ServerEventSet(ServerEvent)	Initializes a new instance of the ServerEventSet class with a specified event.
	ServerEventSet(array<ServerEvent> [] () [] [])	Initializes a new instance of the ServerEventSet class with specified events.
	ServerEventSet(ServerEventSet)	Initializes a new instance of the ServerEventSet class with specified 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
	AddServerRoleMember	Gets a server event that can be included in the event set.
	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.
	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.
	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 an authorization database is altered.
	AlterAuthorizationServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization server 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.
	AlterCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database is altered.
	AlterDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an endpoint is altered.
	AlterEventSession	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.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a function is altered.
	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.
	AlterInstance	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is altered.
	AlterMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterMessage	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.
	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.
	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.
	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 procedure is altered.
	AlterQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the queue is altered.
	AlterRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the remote service binding is altered.
	AlterResourceGovernorConfig	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a role is altered.
	AlterRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a route is altered.
	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.
	AlterServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterServerConfiguration	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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 is altered.
	AlterServiceMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	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.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user is altered.
	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.
	AlterWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	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.
	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.
	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.
	CreateContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a contract is created.
	CreateCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database is created.
	CreateDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	CreateEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an endpoint is created.
	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.
	CreateEventSession	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateExtendedProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a function is created.
	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.
	CreateLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateLinkedServerLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is created.
	CreateMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateMessage	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.
	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.
	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.
	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 procedure is created.
	CreateQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a queue is created.
	CreateRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	CreateResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a role is created.
	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.
	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.
	CreateServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	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.
	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.
	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.
	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.
	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.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user is created.
	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.
	CreateWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	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.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether database deny events are included in the event set.
	DenyServer	Gets or sets a Boolean property value that specifies whether server deny events are included in the event set.
	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.
	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.
	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.
	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.
	DropCredential	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropCryptographicProvider	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database is dropped.
	DropDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	DropEndpoint	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an endpoint is dropped.
	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.
	DropEventSession	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropExtendedProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	DropFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a function is dropped.
	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.
	DropLinkedServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropLinkedServerLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropLogin	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is dropped.
	DropMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropMessage	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.
	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.
	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 schema is dropped.
	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.
	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.
	DropRemoteServer	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	DropResourcePool	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a role is dropped.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	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.
	DropServerAudit	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropServerAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropServerRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropService	Gets or sets a Boolean property value that specifies whether drop service events are included in the event set.
	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.
	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.
	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.
	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.
	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.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user is dropped.
	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.
	DropWorkloadGroup	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	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.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether database grant events are included in the event set.
	GrantServer	Gets or sets a Boolean property value that specifies whether server grant events are included in the event set.
	NumberOfElements	Gets the number of events 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 database revoke events are included in the event set.
	RevokeServer	Gets or sets a Boolean property value that specifies whether server revoke events are included in the event set.
	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 update statistics events are included in the event set.

Início

Métodos

	Nome	Descrição
	Add(ServerEvent)	Returns a server event set after adding a new server event to the referenced event set.
	Add(ServerEventSet, ServerEvent)	Returns a server event set after adding a new server event to the specified event set.
	Copy	Returns a copy of the event set. (Substitui EventSetBase. . :: . .Copy() () () ().)
	Equals	(Herdado de Object.)
	Finalize	(Herdado de Object.)
	FitsMask	Specifies whether the EventSetBase object fits the specified mask. (Herdado de EventSetBase.)
	GetHashCode	(Herdado de Object.)
	GetType	(Herdado de Object.)
	HasCommonBits	Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Herdado de EventSetBase.)
	MemberwiseClone	(Herdado de Object.)
	Remove	Removes an event from the event set.
	SetValue	Sets the bit value at the specified index position. (Herdado de EventSetBase.)
	Subtract	Returns a server event set after subtracting a server event from the specified event set.
	ToString	Returns a string that represents the ServerEventSet object. (Substitui Object. . :: . .ToString() () () ().)

Início

Operadores

	Nome	Descrição
	Addition	Creates a server event set by performing an addition operation on a ServerEvent object and a ServerEventSet object.
	Subtraction	Creates a server event set by performing a subtraction operation on a ServerEvent object and a ServerEventSet object.

Início

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