ServerDdlTriggerEvent-Klasse
The ServerDdlTriggerEvent object represents the Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.
Vererbungshierarchie
System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..ServerDdlTriggerEvent
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
Syntax
'Declaration
Public NotInheritable Class ServerDdlTriggerEvent
'Usage
Dim instance As ServerDdlTriggerEvent
public sealed class ServerDdlTriggerEvent
public ref class ServerDdlTriggerEvent sealed
[<SealedAttribute>]
type ServerDdlTriggerEvent = class end
public final class ServerDdlTriggerEvent
Der ServerDdlTriggerEvent-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
AddRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AddServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AddSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AddSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterAuthorizationDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterAuthorizationServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
AlterBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterCertificate | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
AlterCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
AlterEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterInstance | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
AlterMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterResourceGovernorConfig | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterService | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterServiceMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterView | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
AlterXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
BindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
BindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
CreateEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
CreateMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreatePartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreatePartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreatePlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateService | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateSpatialIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateType | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateView | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateXmlIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
CreateXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DenyDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DenyServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
DropApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropEndpoint | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
DropMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropService | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropType | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropView | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
DropXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
GrantDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
GrantServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
Logon | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
Rename | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
RevokeDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
RevokeServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. | |
UnbindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
UnbindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. | |
UpdateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
Add | Returns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set. | |
BitwiseOr | Creates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects. | |
Equals | (Geerbt von Object.) | |
Finalize | (Geerbt von Object.) | |
GetHashCode | (Geerbt von Object.) | |
GetType | (Geerbt von Object.) | |
MemberwiseClone | (Geerbt von Object.) | |
ToString | Returns the object in String format. (Überschreibt Object. . :: . .ToString() () () ().) |
Zum Anfang
Operatoren
Name | Beschreibung | |
---|---|---|
Addition | Creates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects. | |
BitwiseOr | Creates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects. | |
Implicit Widening Implicit Implicit Implicit(ServerDdlTriggerEvent to ServerDdlTriggerEventSet) | Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object. |
Zum Anfang
Hinweise
DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The ServerDdlTriggerEvent object contains a property for each event to which the server DDL trigger can respond. The actual set of events is specified using the ServerDdlTriggerEventSet object.
Thread Safety
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch