DatabaseEventSet Members

The DatabaseEventSet object represents a Microsoft SQL Server set of database events.

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

Public Constructors

	이름	Description
	DatabaseEventSet	Overloaded. Initializes a new instance of the DatabaseEventSet class.

위쪽

Public Properties

(see also Protected Properties )

	이름	Description
	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.
	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 in the database.
	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 in the database.
	AlterAuthorizationDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the authorization database 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 in the database.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	AlterProcedure	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 altered in the database.
	AlterQueue	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 altered in the database.
	AlterRemoteServiceBinding	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 altered in the database.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered in the database.
	AlterRoute	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 altered in the database.
	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 in the database.
	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 Broker service is altered in the database.
	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 in the database.
	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 in the database.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	CreateContract	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 created in the database.
	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 in the database.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	CreateProcedure	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 created in the database.
	CreateQueue	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 created in the database.
	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 in the database.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created in the database.
	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 in the database.
	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 in the database.
	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 in the database.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access the database is denied.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	DropDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database 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 from the database.
	DropFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 scheme is dropped from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped from the database.
	DropRoleMember	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 dropped from a database role in the database.
	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 from the database.
	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 from the database.
	DropService	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 dropped from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	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 from the database.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped from the database.
	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 from the database.
	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 from the database.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
	NumberOfElements	Overridden. Gets the number of events included in the event set.
	RevokeDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access to the database is revoked.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the statistics are updated in the database.

위쪽

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 set of database events after adding a new database event to the event set.
	Copy	Overridden. Returns a copy of the DatabaseEventSet object.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	op_Addition	Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
	op_Subtraction	Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.
	ReferenceEquals	(inherited from Object )
	Remove	Removes an event from the event set.
	Subtract	Returns a set of database events after removing a database event from the specified event set.
	ToString	Overridden. Returns a string that represents the DatabaseEventSet object.

위쪽

Protected Methods

	이름	Description
	Finalize	(inherited from Object )
	FitsMask	(inherited from EventSetBase )
	HasCommonBits	(inherited from EventSetBase )
	MemberwiseClone	(inherited from Object )
	SetValue	(inherited from EventSetBase )

위쪽

참고 항목

참조

DatabaseEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

관련 자료

Handling SMO Events