Costruttore ServerDdlTrigger (Server, String, ServerDdlTriggerEventSet, String, String, String)

Initializes a new instance of the ServerDdlTrigger class on the specified instance of SQL Server and that has the specified name. The trigger responds to the specified event set and runs the specified batch.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Sub New ( _
    parent As Server, _
    name As String, _
    events As ServerDdlTriggerEventSet, _
    assemblyName As String, _
    className As String, _
    method As String _
)
'Utilizzo
Dim parent As Server 
Dim name As String 
Dim events As ServerDdlTriggerEventSet 
Dim assemblyName As String 
Dim className As String 
Dim method As String 

Dim instance As New ServerDdlTrigger(parent, _
    name, events, assemblyName, className, _
    method)
public ServerDdlTrigger(
    Server parent,
    string name,
    ServerDdlTriggerEventSet events,
    string assemblyName,
    string className,
    string method
)
public:
ServerDdlTrigger(
    Server^ parent, 
    String^ name, 
    ServerDdlTriggerEventSet^ events, 
    String^ assemblyName, 
    String^ className, 
    String^ method
)
new : 
        parent:Server * 
        name:string * 
        events:ServerDdlTriggerEventSet * 
        assemblyName:string * 
        className:string * 
        method:string -> ServerDdlTrigger
public function ServerDdlTrigger(
    parent : Server, 
    name : String, 
    events : ServerDdlTriggerEventSet, 
    assemblyName : String, 
    className : String, 
    method : String
)

Parametri

  • name
    Tipo: System.String
    A String value that specifies the name of the server data definition language (DDL) trigger.
  • assemblyName
    Tipo: System.String
    A String value that specifies the name of the registered assembly that contains the user-defined function that runs when the DDL trigger is raised.
  • className
    Tipo: System.String
    A String value that specifies the name of the class in the registered assembly.
  • method
    Tipo: System.String
    A String value that specifies the method within the class that runs when the DDL trigger is raised.

Esempi

Creazione, modifica e rimozione di trigger

Vedere anche

Riferimento

ServerDdlTrigger Classe

Overload ServerDdlTrigger

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Trigger DDL

CREATE TRIGGER (Transact-SQL)