ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String)
Initializes a new instance of the ServerDdlTrigger class on the specified database that has the specified name. The trigger responds to the specified event set and runs the specified batch.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Sub New ( _
parent As Server, _
name As String, _
events As ServerDdlTriggerEventSet, _
textBody As String _
)
'Uso
Dim parent As Server
Dim name As String
Dim events As ServerDdlTriggerEventSet
Dim textBody As String
Dim instance As New ServerDdlTrigger(parent, _
name, events, textBody)
public ServerDdlTrigger(
Server parent,
string name,
ServerDdlTriggerEventSet events,
string textBody
)
public:
ServerDdlTrigger(
Server^ parent,
String^ name,
ServerDdlTriggerEventSet^ events,
String^ textBody
)
new :
parent:Server *
name:string *
events:ServerDdlTriggerEventSet *
textBody:string -> ServerDdlTrigger
public function ServerDdlTrigger(
parent : Server,
name : String,
events : ServerDdlTriggerEventSet,
textBody : String
)
Parámetros
- parent
Tipo: Microsoft.SqlServer.Management.Smo.Server
A Server object value that specifies the parent of the ServerDdlTrigger object.
- name
Tipo: System.String
A String value that specifies the name of the server data definition language (DDL) trigger.
- events
Tipo: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet
A ServerDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.
- textBody
Tipo: System.String
A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.
Ejemplos
Crear, modificar y eliminar desencadenadores
Vea también
Referencia
Sobrecarga de ServerDdlTrigger
Espacio de nombres Microsoft.SqlServer.Management.Smo