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

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)

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

Parameters

parent
Type: Microsoft.SqlServer.Management.Smo.Database
A Database object value that specifies the parent of the DatabaseDdlTrigger object.
name
Type: System.String
A String value that specifies the name of the database data definition language (DDL) trigger.
events
Type: Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerEventSet
A DatabaseDdlTriggerEventSet 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.

Community Additions

ADD
Show: