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
Name | Description | |
---|---|---|
DatabaseEventSet | Overloaded. Initializes a new instance of the DatabaseEventSet class. |
Nach oben
Public Properties
(see also Protected Properties )
Name | 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. |
Nach oben
Protected Properties
Name | Description | |
---|---|---|
![]() |
Storage | Gets or sets the bit array for event set storage. (inherited from EventSetBase) |
Nach oben
Public Methods
(see also Protected Methods )
Name | 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. |
Nach oben
Protected Methods
Name | Description | |
---|---|---|
![]() |
Finalize | (inherited from Object ) |
![]() |
FitsMask | (inherited from EventSetBase ) |
![]() |
HasCommonBits | (inherited from EventSetBase ) |
![]() |
MemberwiseClone | (inherited from Object ) |
![]() |
SetValue | (inherited from EventSetBase ) |
Nach oben
Siehe auch
Verweis
DatabaseEventSet Class
Microsoft.SqlServer.Management.Smo Namespace