ServerEventSet Members

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

	名稱	Description
	ServerEventSet	Overloaded. Initializes a new instance of the ServerEventSet class.

頂端

Public Properties

(see also Protected Properties )

	名稱	Description
	AddRoleMember
	AddServerRoleMember
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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
	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.
	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.
	DropServerRoleMember
	DropService	Gets or sets a Boolean property value that specifies whether drop service events are 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.
	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.
	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	Overridden. Gets the number of events 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.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether update statistics events are included in the event set.

頂端

Protected Properties

	名稱	Description
	Storage	Gets or sets the bit array for event set storage. (inherited from EventSetBase)

頂端

Public Methods

(see also Protected Methods )

	名稱	Description
	Add	Overloaded. Returns a server event set after adding a new server event to the event set.
	Copy	Overridden. Returns a copy of the event set.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	op_Addition	Creates a server event set by performing an addition operation on a ServerEvent object and a ServerEventSet object.
	op_Subtraction	Creates a server event set by performing a subtraction operation on a ServerEvent object and a ServerEventSet object.
	ReferenceEquals	(inherited from Object )
	Remove	Removes an event from the event set.
	Subtract	Returns a server event set after subtracting a server event from the specified event set.
	ToString	Overridden. Returns a string that represents the ServerEventSet object.

頂端

Protected Methods

	名稱	Description
	Finalize	(inherited from Object )
	FitsMask	(inherited from EventSetBase )
	HasCommonBits	(inherited from EventSetBase )
	MemberwiseClone	(inherited from Object )
	SetValue	(inherited from EventSetBase )

頂端

請參閱

參考

ServerEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Handling SMO Events