Export (0) Print
Expand All

ServerEventSet Class

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

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)

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

The ServerEventSet type exposes the following members.

  NameDescription
Public methodServerEventSet()Initializes a new instance of the ServerEventSet class.
Public methodServerEventSet(ServerEvent)Initializes a new instance of the ServerEventSet class with a specified event.
Public methodServerEventSet(ServerEvent[])Initializes a new instance of the ServerEventSet class with specified events.
Public methodServerEventSet(ServerEventSet)Initializes a new instance of the ServerEventSet class with specified events.
Top

  NameDescription
Public propertyAddRoleMemberGets 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 propertyAddServerRoleMemberGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAddSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAddSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterApplicationRoleGets 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 propertyAlterAssemblyGets 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 propertyAlterAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterAuthorizationDatabaseGets 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 propertyAlterAuthorizationServerGets 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 propertyAlterAvailabilityGroupGets 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 propertyAlterBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterCertificateGets 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 propertyAlterCredentialGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterCryptographicProviderGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterDatabaseGets 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 propertyAlterDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterEndpointGets 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 propertyAlterEventSessionGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterFunctionGets 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 propertyAlterIndexGets 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 propertyAlterInstanceGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterLinkedServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterLoginGets 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 propertyAlterMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterMessageGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterMessageTypeGets 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 propertyAlterPartitionFunctionGets 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 propertyAlterPartitionSchemeGets 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 propertyAlterPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterProcedureGets 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 propertyAlterQueueGets 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 propertyAlterRemoteServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterRemoteServiceBindingGets 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 propertyAlterResourceGovernorConfigGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterResourcePoolGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterRoleGets 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 propertyAlterRouteGets 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 propertyAlterSchemaGets 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 propertyAlterSearchPropertyListGets 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 propertyAlterSequenceGets 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 propertyAlterServerAuditGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterServerAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterServerConfigurationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterServerRoleGets 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 propertyAlterServiceGets 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 propertyAlterServiceMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterTableGets 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 propertyAlterTriggerGets 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 propertyAlterUserGets 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 propertyAlterViewGets 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 propertyAlterWorkloadGroupGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAlterXmlSchemaCollectionGets 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 propertyBindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyBindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateApplicationRoleGets 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 propertyCreateAssemblyGets 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 propertyCreateAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateAvailabilityGroupGets 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 propertyCreateBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateCertificateGets 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 propertyCreateContractGets 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 propertyCreateCredentialGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateCryptographicProviderGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateDatabaseGets 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 propertyCreateDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateEndpointGets 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 propertyCreateEventNotificationGets 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 propertyCreateEventSessionGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateExtendedProcedureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateFunctionGets 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 propertyCreateIndexGets 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 propertyCreateLinkedServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateLinkedServerLoginGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateLoginGets 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 propertyCreateMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateMessageGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateMessageTypeGets 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 propertyCreatePartitionFunctionGets 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 propertyCreatePartitionSchemeGets 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 propertyCreatePlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateProcedureGets 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 propertyCreateQueueGets 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 propertyCreateRemoteServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateRemoteServiceBindingGets 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 propertyCreateResourcePoolGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateRoleGets 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 propertyCreateRouteGets 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 propertyCreateRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSchemaGets 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 propertyCreateSearchPropertyListGets 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 propertyCreateSequenceGets 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 propertyCreateServerAuditGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateServerAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateServerRoleGets 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 propertyCreateServiceGets 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 propertyCreateSpatialIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateStatisticsGets 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 propertyCreateSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateSynonymGets 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 propertyCreateTableGets 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 propertyCreateTriggerGets 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 propertyCreateTypeGets 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 propertyCreateUserGets 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 propertyCreateViewGets 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 propertyCreateWorkloadGroupGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyCreateXmlIndexGets 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 propertyCreateXmlSchemaCollectionGets 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 propertyDenyDatabaseGets or sets a Boolean property value that specifies whether database deny events are included in the event set.
Public propertyDenyServerGets or sets a Boolean property value that specifies whether server deny events are included in the event set.
Public propertyDropApplicationRoleGets 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 propertyDropAssemblyGets 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 propertyDropAsymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropAvailabilityGroupGets 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 propertyDropBrokerPriorityGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropCertificateGets 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 propertyDropContractGets 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 propertyDropCredentialGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropCryptographicProviderGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropDatabaseGets 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 propertyDropDatabaseAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropDatabaseEncryptionKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropEndpointGets 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 propertyDropEventNotificationGets 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 propertyDropEventSessionGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropExtendedProcedureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropExtendedPropertyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextCatalogGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextIndexGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFulltextStoplistGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropFunctionGets 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 propertyDropIndexGets 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 propertyDropLinkedServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropLinkedServerLoginGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropLoginGets 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 propertyDropMasterKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropMessageGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropMessageTypeGets 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 propertyDropPartitionFunctionGets 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 propertyDropPartitionSchemeGets 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 propertyDropPlanGuideGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropProcedureGets 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 propertyDropQueueGets 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 propertyDropRemoteServerGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropRemoteServiceBindingGets 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 propertyDropResourcePoolGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropRoleGets 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 propertyDropRoleMemberGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropRouteGets 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 propertyDropRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSchemaGets 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 propertyDropSearchPropertyListGets 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 propertyDropSequenceGets 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 propertyDropServerAuditGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropServerAuditSpecificationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropServerRoleGets 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 propertyDropServerRoleMemberGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropServiceGets or sets a Boolean property value that specifies whether drop service events are included in the event set.
Public propertyDropSignatureGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSignatureSchemaObjectGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropStatisticsGets 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 propertyDropSymmetricKeyGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropSynonymGets 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 propertyDropTableGets 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 propertyDropTriggerGets 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 propertyDropTypeGets 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 propertyDropUserGets 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 propertyDropViewGets 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 propertyDropWorkloadGroupGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDropXmlSchemaCollectionGets 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 propertyGrantDatabaseGets or sets a Boolean property value that specifies whether database grant events are included in the event set.
Public propertyGrantServerGets or sets a Boolean property value that specifies whether server grant events are included in the event set.
Public propertyNumberOfElementsGets the number of events in the event set. (Overrides EventSetBase.NumberOfElements.)
Public propertyRenameGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyRevokeDatabaseGets or sets a Boolean property value that specifies whether database revoke events are included in the event set.
Public propertyRevokeServerGets or sets a Boolean property value that specifies whether server revoke events are included in the event set.
Protected propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public propertyUnbindDefaultGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUnbindRuleGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyUpdateStatisticsGets or sets a Boolean property value that specifies whether update statistics events are included in the event set.
Top

  NameDescription
Public methodAdd(ServerEvent)Returns a server event set after adding a new server event to the referenced event set.
Public methodStatic memberAdd(ServerEventSet, ServerEvent)Returns a server event set after adding a new server event to the specified event set.
Public methodCopyReturns a copy of the event set. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Public methodStatic memberSubtractReturns a server event set after subtracting a server event from the specified event set.
Public methodToStringReturns a string that represents the ServerEventSet object. (Overrides ObjectToString.)
Top

  NameDescription
Public operatorStatic memberAdditionCreates a server event set by performing an addition operation on a ServerEvent object and a ServerEventSet object.
Public operatorStatic memberSubtractionCreates a server event set by performing a subtraction operation on a ServerEvent object and a ServerEventSet object.
Top

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

Community Additions

ADD
Show:
© 2014 Microsoft