Freigeben über


DatabaseEventSet-Klasse

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

Vererbungshierarchie

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.DatabaseEventSet

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class DatabaseEventSet _
    Inherits EventSetBase
'Usage
Dim instance As DatabaseEventSet
public sealed class DatabaseEventSet : EventSetBase
public ref class DatabaseEventSet sealed : public EventSetBase
[<SealedAttribute>]
type DatabaseEventSet =  
    class 
        inherit EventSetBase 
    end
public final class DatabaseEventSet extends EventSetBase

Der DatabaseEventSet-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode DatabaseEventSet() Initializes a new instance of the DatabaseEventSet class.
Öffentliche Methode DatabaseEventSet(DatabaseEvent) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Öffentliche Methode DatabaseEventSet(array<DatabaseEvent[]) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
Öffentliche Methode DatabaseEventSet(DatabaseEventSet) Initializes a new instance of the DatabaseEventSet class with a specified set of events.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AddSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft AddSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
Öffentliche Eigenschaft AlterDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft AlterExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft AlterFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft AlterFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is altered in the database.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterSearchPropertyList 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.
Öffentliche Eigenschaft AlterSequence 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft AlterSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft BindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft BindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft CreateBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created in the database.
Öffentliche Eigenschaft CreateDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft CreateDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft CreateFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft CreateFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is created in the database.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreatePlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateSearchPropertyList 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.
Öffentliche Eigenschaft CreateSequence 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft CreateSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
Öffentliche Eigenschaft DropDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text Search, stop list is dropped from the database.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropSearchPropertyList 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.
Öffentliche Eigenschaft DropSequence 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft DropSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft DropSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft NumberOfElements Gets the number of events included in the event set. (Überschreibt EventSetBase.NumberOfElements.)
Öffentliche Eigenschaft Rename Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.
Geschützte Eigenschaft Storage Gets or sets the bit array for event set storage. (Geerbt von EventSetBase.)
Öffentliche Eigenschaft UnbindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft UnbindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Öffentliche Eigenschaft 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.

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode Add(DatabaseEvent) Returns a set of database events after adding a new database event to the referenced event set.
Öffentliche MethodeStatisches Element Add(DatabaseEventSet, DatabaseEvent) Returns a set of database events after adding a new database event to the specified event set.
Öffentliche Methode Copy Returns a copy of the DatabaseEventSet object. (Überschreibt EventSetBase.Copy().)
Öffentliche Methode Equals (Geerbt von Object.)
Öffentliche Methode GetHashCode (Geerbt von Object.)
Öffentliche Methode GetType (Geerbt von Object.)
Öffentliche Methode Remove Removes an event from the event set.
Öffentliche MethodeStatisches Element Subtract Returns a set of database events after removing a database event from the specified event set.
Öffentliche Methode ToString Returns a string that represents the DatabaseEventSet object. (Überschreibt Object.ToString().)

Zum Anfang

Operatoren

  Name Beschreibung
Öffentlicher OperatorStatisches Element Addition Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
Öffentlicher OperatorStatisches Element Subtraction Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.

Zum Anfang

Hinweise

The DatabaseEventSet object is required to specify the set of events that apply to the events that are generated by the database.

Thread Safety

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.

Beispiele

Behandeln von SMO-Ereignissen

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Management.Smo-Namespace