ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String)

Initializes a new instance of the ServerDdlTrigger 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 Server, _
    name As String, _
    events As ServerDdlTriggerEventSet, _
    textBody As String _
)

public ServerDdlTrigger (
    Server parent,
    string name,
    ServerDdlTriggerEventSet events,
    string textBody
)

public:
ServerDdlTrigger (
    Server^ parent, 
    String^ name, 
    ServerDdlTriggerEventSet^ events, 
    String^ textBody
)

public ServerDdlTrigger (
    Server parent, 
    String name, 
    ServerDdlTriggerEventSet events, 
    String textBody
)

public function ServerDdlTrigger (
    parent : Server, 
    name : String, 
    events : ServerDdlTriggerEventSet, 
    textBody : String
)

Paramètres

• parent
  A Server object value that specifies the parent of the ServerDdlTrigger object.

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

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

• textBody
  A String value that specifies the Transact-SQL batch statement that runs when the trigger has been 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: Create, Alter, and Remove a Trigger 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

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

Autres ressources

Creating, Altering, and Removing Triggers
Déclencheurs DDL
CREATE TRIGGER (Transact-SQL)