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