다음을 통해 공유


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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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.
공용 속성 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에서 상속됨)
공용 메서드 GetHashCode (Object에서 상속됨)
공용 메서드 GetType (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 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

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

SMO 이벤트 처리

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Management.Smo 네임스페이스