DatabaseDdlTrigger Constructor (Database, String, DatabaseDdlTriggerEventSet, String, String, String)

Article
12/15/2008

Initializes a new instance of the DatabaseDdlTrigger class on the specified database with 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 (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public Sub New ( _
    parent As Database, _
    name As String, _
    events As DatabaseDdlTriggerEventSet, _
    assemblyName As String, _
    className As String, _
    method As String _
)

public DatabaseDdlTrigger (
    Database parent,
    string name,
    DatabaseDdlTriggerEventSet events,
    string assemblyName,
    string className,
    string method
)

public:
DatabaseDdlTrigger (
    Database^ parent, 
    String^ name, 
    DatabaseDdlTriggerEventSet^ events, 
    String^ assemblyName, 
    String^ className, 
    String^ method
)

public DatabaseDdlTrigger (
    Database parent, 
    String name, 
    DatabaseDdlTriggerEventSet events, 
    String assemblyName, 
    String className, 
    String method
)

public function DatabaseDdlTrigger (
    parent : Database, 
    name : String, 
    events : DatabaseDdlTriggerEventSet, 
    assemblyName : String, 
    className : String, 
    method : String
)

Paramètres

parent
A Database object value that specifies the parent of the DatabaseDdlTrigger object.

name
A String value that specifies the name of the database data definition language (DDL) trigger.

events
A DatabaseDdlTriggerEventSet object that specifies the DDL events to which the DDL trigger responds.

assemblyName
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
A String value that specifies the name of the class in the registered assembly.

method
A String value that specifies the method within the class that runs when the DDL trigger is raised.

Notes

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Exemple

How to: Construct an Object in Visual Basic .NET

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

DatabaseDdlTrigger Class
DatabaseDdlTrigger Members
Microsoft.SqlServer.Management.Smo Namespace

Autres ressources

CREATE TRIGGER (Transact-SQL)
Déclencheurs DDL

Partager via