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
Nome | Description | |
---|---|---|
DatabaseEventSet | Overloaded. Initializes a new instance of the DatabaseEventSet class. |
Torna all'inizio
Public Properties
(see also Protected Properties )
Nome | 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. |
Torna all'inizio
Protected Properties
Nome | Description | |
---|---|---|
Storage | Gets or sets the bit array for event set storage. (inherited from EventSetBase) |
Torna all'inizio
Public Methods
(see also Protected Methods )
Nome | 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. |
Torna all'inizio
Protected Methods
Nome | Description | |
---|---|---|
Finalize | (inherited from Object ) | |
FitsMask | (inherited from EventSetBase ) | |
HasCommonBits | (inherited from EventSetBase ) | |
MemberwiseClone | (inherited from Object ) | |
SetValue | (inherited from EventSetBase ) |
Torna all'inizio
Vedere anche
Riferimento
DatabaseEventSet Class
Microsoft.SqlServer.Management.Smo Namespace