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)
Syntax
'Declaration
Public Sub New ( _
parent As Server, _
name As String, _
events As ServerDdlTriggerEventSet, _
textBody As String _
)
'Usage
Dim parent As Server
Dim name As String
Dim events As ServerDdlTriggerEventSet
Dim textBody As String
Dim instance As New ServerDdlTrigger(parent, _
name, events, textBody)
public ServerDdlTrigger(
Server parent,
string name,
ServerDdlTriggerEventSet events,
string textBody
)
public:
ServerDdlTrigger(
Server^ parent,
String^ name,
ServerDdlTriggerEventSet^ events,
String^ textBody
)
new :
parent:Server *
name:string *
events:ServerDdlTriggerEventSet *
textBody:string -> ServerDdlTrigger
public function ServerDdlTrigger(
parent : Server,
name : String,
events : ServerDdlTriggerEventSet,
textBody : String
)
Parameters
- parent
Type: Microsoft.SqlServer.Management.Smo.Server
A Server object value that specifies the parent of the ServerDdlTrigger object.
- name
Type: System.String
A String value that specifies the name of the server data definition language (DDL) trigger.
- events
Type: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEventSet
A ServerDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.
- textBody
Type: System.String
A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.
Examples
Creating, Altering, and Removing Triggers
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace