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