Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
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.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Sub New ( _
parent As Server, _
name As String, _
events As ServerDdlTriggerEventSet, _
assemblyName As String, _
className As String, _
method As String _
)
'Utilisation
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
)
Paramètres
- parent
Type : Microsoft.SqlServer.Management.Smo.Server
A Server object value that specifies the parent of the ServerDdlTrigger object.
- name
Type : System.String
A String value that specifies the name of the server data definition language (DDL) trigger.
- events
Type : Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet
A ServerDdlTriggerEventSet object that specifies the DDL events to which the DDL trigger responds.
- assemblyName
Type : 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
Type : System.String
A String value that specifies the name of the class in the registered assembly.
- method
Type : System.String
A String value that specifies the method within the class that runs when the DDL trigger is raised.
Exemples
Création, modification et suppression de déclencheurs
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo