Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String)


Initializes a new instance of the ServerDdlTrigger class on the specified database that has 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 ServerDdlTrigger(
	Server parent,
	string name,
	ServerDdlTriggerEventSet events,
	string textBody


Type: Microsoft.SqlServer.Management.Smo.Server

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

Type: System.String

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

Type: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet

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

Type: System.String

A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft