ServerEventSet Members

  • Article

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

The following tables list the members exposed by the ServerEventSet type.

Public Constructors

  Name Description
ServerEventSet Overloaded. Initializes a new instance of the ServerEventSet class.

Top

Public Properties

(see also Protected Properties )

  Name Description
ms220226.pubproperty(en-US,SQL.90).gif AddRoleMember  
ms220226.pubproperty(en-US,SQL.90).gif AddServerRoleMember  
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif DenyDatabase Gets or sets a Boolean property value that specifies whether database deny events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif DenyServer Gets or sets a Boolean property value that specifies whether server deny events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif DropRoleMember  
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif DropServerRoleMember  
ms220226.pubproperty(en-US,SQL.90).gif DropService Gets or sets a Boolean property value that specifies whether drop service events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif 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.
ms220226.pubproperty(en-US,SQL.90).gif GrantDatabase Gets or sets a Boolean property value that specifies whether database grant events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif GrantServer Gets or sets a Boolean property value that specifies whether server grant events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif NumberOfElements Overridden. Gets the number of events in the event set.
ms220226.pubproperty(en-US,SQL.90).gif RevokeDatabase Gets or sets a Boolean property value that specifies whether database revoke events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif RevokeServer Gets or sets a Boolean property value that specifies whether server revoke events are included in the event set.
ms220226.pubproperty(en-US,SQL.90).gif UpdateStatistics Gets or sets a Boolean property value that specifies whether update statistics events are included in the event set.

Top

Protected Properties

  Name Description
ms220226.protproperty(en-US,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220226.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a server event set after adding a new server event to the event set.
ms220226.pubmethod(en-US,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms220226.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220226.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220226.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220226.pubmethod(en-US,SQL.90).gifms220226.static(en-US,SQL.90).gif op_Addition Creates a server event set by performing an addition operation on a ServerEvent object and a ServerEventSet object.
ms220226.pubmethod(en-US,SQL.90).gifms220226.static(en-US,SQL.90).gif op_Subtraction Creates a server event set by performing a subtraction operation on a ServerEvent object and a ServerEventSet object.
ms220226.pubmethod(en-US,SQL.90).gifms220226.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220226.pubmethod(en-US,SQL.90).gif Remove Removes an event from the event set.
ms220226.pubmethod(en-US,SQL.90).gifms220226.static(en-US,SQL.90).gif Subtract Returns a server event set after subtracting a server event from the specified event set.
ms220226.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a string that represents the ServerEventSet object.

Top

Protected Methods

  Name Description
ms220226.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220226.protmethod(en-US,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms220226.protmethod(en-US,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms220226.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220226.protmethod(en-US,SQL.90).gif SetValue  (inherited from EventSetBase )

Top

See Also

Reference

ServerEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events