Compartir a través de


Clase ServerDdlTriggerEvent

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.

Jerarquía de herencia

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo..::..ServerDdlTriggerEvent

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SqlEnum (en Microsoft.SqlServer.SqlEnum.dll)

Sintaxis

'Declaración
Public NotInheritable Class ServerDdlTriggerEvent
'Uso
Dim instance As ServerDdlTriggerEvent
public sealed class ServerDdlTriggerEvent
public ref class ServerDdlTriggerEvent sealed
[<SealedAttribute>]
type ServerDdlTriggerEvent =  class end
public final class ServerDdlTriggerEvent

El tipo ServerDdlTriggerEvent expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad públicaMiembro estático AddRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AddServerRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AddSignature Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AddSignatureSchemaObject Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterAuthorizationDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterAuthorizationServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterCertificate Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterEndpoint Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterInstance Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterPartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterPartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterPlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterResourceGovernorConfig Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterServiceMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático AlterXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático BindDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático BindRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateCertificate Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateContract Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateEndpoint Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateEventNotification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateExtendedProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateLinkedServerLogin Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreatePartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreatePartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreatePlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateSpatialIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateSynonym Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateXmlIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático CreateXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DenyDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DenyServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropApplicationRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropAssembly Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropAsymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropBrokerPriority Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropCertificate Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropContract Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropCredential Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropCryptographicProvider Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropDatabaseAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropDatabaseEncryptionKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropEndpoint Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropEventNotification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropEventSession Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropExtendedProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropExtendedProperty Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropFulltextCatalog Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropFulltextIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropFulltextStoplist Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropIndex Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropLinkedServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropLinkedServerLogin Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropLogin Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropMasterKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropMessage Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropMessageType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropPartitionFunction Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropPartitionScheme Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropPlanGuide Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropProcedure Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropQueue Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRemoteServer Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRemoteServiceBinding Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropResourcePool Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRole Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRoute Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropSchema Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropServerAudit Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropServerAuditSpecification Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropServerRoleMember Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropService Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropSignature Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropSignatureSchemaObject Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropSymmetricKey Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropSynonym Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropTable Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropTrigger Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropType Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropUser Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropView Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropWorkloadGroup Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático DropXmlSchemaCollection Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático GrantDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático GrantServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático Logon Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático Rename Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático RevokeDatabase Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático RevokeServer Gets a server data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático UnbindDefault Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático UnbindRule Gets a database data definition language (DDL) trigger event that can be included in the event set.
Propiedad públicaMiembro estático UpdateStatistics Gets a database data definition language (DDL) trigger event that can be included in the event set.

Arriba

Métodos

  Nombre Descripción
Método públicoMiembro estático Add Returns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set.
Método públicoMiembro estático BitwiseOr Creates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects.
Método público Equals (Se hereda de Object.)
Método protegido Finalize (Se hereda de Object.)
Método público GetHashCode (Se hereda de Object.)
Método público GetType (Se hereda de Object.)
Método protegido MemberwiseClone (Se hereda de Object.)
Método público ToString Returns the object in String format. (Invalida Object. . :: . .ToString() () () ().)

Arriba

Operadores

  Nombre Descripción
Operador públicoMiembro estático Addition Creates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects.
Operador públicoMiembro estático BitwiseOr Creates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects.
Operador públicoMiembro estático Implicit Widening Implicit Implicit Implicit(ServerDdlTriggerEvent to ServerDdlTriggerEventSet) Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object.

Arriba

Comentarios

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.