DatabaseEventSet 类

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

继承层次结构

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

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public NotInheritable Class DatabaseEventSet _
    Inherits EventSetBase
用法
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

DatabaseEventSet 类型公开以下成员。

构造函数

  名称 说明
公共方法 DatabaseEventSet() () () () Initializes a new instance of the DatabaseEventSet class.
公共方法 DatabaseEventSet(DatabaseEvent) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
公共方法 DatabaseEventSet(array<DatabaseEvent> [] () [] []) Initializes a new instance of the DatabaseEventSet class with a specified set of events.
公共方法 DatabaseEventSet(DatabaseEventSet) Initializes a new instance of the DatabaseEventSet class with a specified set of events.

页首

属性

  名称 说明
公共属性 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.
公共属性 AddSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 AddSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 AlterAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 AlterBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 AlterDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 AlterExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 AlterFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 AlterMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 AlterPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 AlterSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 BindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 BindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreateAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 CreateBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 CreateDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 CreateDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreateExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 CreateFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 CreateMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreatePlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreateRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 CreateSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 DropAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 DropBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 DropDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 DropDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 DropExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 DropFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 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.
公共属性 DropMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 DropPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 DropRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.
公共属性 DropSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 DropSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is 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 from the database.
公共属性 DropSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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 Gets the number of events included in the event set. (覆盖 EventSetBase. . :: . .NumberOfElements。)
公共属性 Rename Gets or sets a Boolean property value that specifies whether the event is 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.
受保护属性 Storage Gets or sets the bit array for event set storage. (从 EventSetBase 继承。)
公共属性 UnbindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 UnbindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
公共属性 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.

页首

方法

  名称 说明
公共方法 Add(DatabaseEvent) Returns a set of database events after adding a new database event to the referenced event set.
公共方法静态成员 Add(DatabaseEventSet, DatabaseEvent) Returns a set of database events after adding a new database event to the specified event set.
公共方法 Copy Returns a copy of the DatabaseEventSet object. (覆盖 EventSetBase. . :: . .Copy() () () ()。)
公共方法 Equals (从 Object 继承。)
受保护方法 Finalize (从 Object 继承。)
受保护方法 FitsMask Specifies whether the EventSetBase object fits the specified mask. (从 EventSetBase 继承。)
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetType (从 Object 继承。)
受保护方法 HasCommonBits Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (从 EventSetBase 继承。)
受保护方法 MemberwiseClone (从 Object 继承。)
公共方法 Remove Removes an event from the event set.
受保护方法 SetValue Sets the bit value at the specified index position. (从 EventSetBase 继承。)
公共方法静态成员 Subtract Returns a set of database events after removing a database event from the specified event set.
公共方法 ToString Returns a string that represents the DatabaseEventSet object. (覆盖 Object. . :: . .ToString() () () ()。)

页首

运算符

  名称 说明
公共运算符静态成员 Addition Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
公共运算符静态成员 Subtraction Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.

页首

注释

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

Thread Safety

此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。