ServerEventSet Class

  • Article

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

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class ServerEventSet _
    Inherits EventSetBase
'Usage
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

The ServerEventSet type exposes the following members.

Constructors

  Name Description
Public method ServerEventSet() Initializes a new instance of the ServerEventSet class.
Public method ServerEventSet(ServerEvent) Initializes a new instance of the ServerEventSet class with a specified event.
Public method ServerEventSet(array<ServerEvent[]) Initializes a new instance of the ServerEventSet class with specified events.
Public method ServerEventSet(ServerEventSet) Initializes a new instance of the ServerEventSet class with specified events.

Top

Properties

  Name Description
Public property 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
Public property AddServerRoleMember Gets a server event that can be included in the event set.
Public property AddSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AddSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterAvailabilityGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an availability group is altered.
Public property AlterBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterCredential Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterCryptographicProvider Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterEventSession Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterInstance Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterLinkedServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterMessage Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property AlterPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property AlterRemoteServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property AlterResourceGovernorConfig Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterResourcePool Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property AlterServerAudit Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterServerAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterServerConfiguration Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterServerRole 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.
Public property 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.
Public property AlterServiceMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property AlterWorkloadGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property BindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property BindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateAvailabilityGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an availability group is created.
Public property CreateBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateCredential Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateCryptographicProvider Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateEventSession Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateExtendedProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateLinkedServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateLinkedServerLogin Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateMessage Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property CreatePlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateRemoteServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateResourcePool Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property CreateRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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 altered.
Public property 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 altered.
Public property CreateServerAudit Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateServerAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateServerRole 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.
Public property 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.
Public property CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property CreateSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property CreateWorkloadGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DenyDatabase Gets or sets a Boolean property value that specifies whether database deny events are included in the event set.
Public property DenyServer Gets or sets a Boolean property value that specifies whether server deny events are included in the event set.
Public property 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.
Public property 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.
Public property DropAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropAvailabilityGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an availability group is dropped.
Public property DropBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DropCredential Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropCryptographicProvider Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DropEventSession Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropExtendedProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DropLinkedServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropLinkedServerLogin Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropMessage Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property DropPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property DropRemoteServer Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropResourcePool Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property DropServerAudit Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropServerAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropServerRole 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.
Public property DropServerRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropService Gets or sets a Boolean property value that specifies whether drop service events are included in the event set.
Public property DropSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property DropSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property DropWorkloadGroup Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property 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.
Public property GrantDatabase Gets or sets a Boolean property value that specifies whether database grant events are included in the event set.
Public property GrantServer Gets or sets a Boolean property value that specifies whether server grant events are included in the event set.
Public property NumberOfElements Gets the number of events in the event set. (Overrides EventSetBase.NumberOfElements.)
Public property Rename Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property RevokeDatabase Gets or sets a Boolean property value that specifies whether database revoke events are included in the event set.
Public property RevokeServer Gets or sets a Boolean property value that specifies whether server revoke events are included in the event set.
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public property UnbindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property UnbindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property UpdateStatistics Gets or sets a Boolean property value that specifies whether update statistics events are included in the event set.

Top

Methods

  Name Description
Public method Add(ServerEvent) Returns a server event set after adding a new server event to the referenced event set.
Public methodStatic member Add(ServerEventSet, ServerEvent) Returns a server event set after adding a new server event to the specified event set.
Public method Copy Returns a copy of the event set. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method Remove Removes an event from the event set.
Public methodStatic member Subtract Returns a server event set after subtracting a server event from the specified event set.
Public method ToString Returns a string that represents the ServerEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a server event set by performing an addition operation on a ServerEvent object and a ServerEventSet object.
Public operatorStatic member Subtraction Creates a server event set by performing a subtraction operation on a ServerEvent object and a ServerEventSet object.

Top

Examples

Handling SMO Events

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace