Jaa

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

  • Artikkeli

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.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
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
)

Parameters

  • name
    A String value that specifies the name of the database data definition language (DDL) trigger.
  • 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.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Construct an Object in Visual Basic .NET

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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

Other Resources

CREATE TRIGGER (Transact-SQL)
DDL Triggers