ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String, String, String)

Initializes a new instance of the ServerDdlTrigger class on the specified instance of Microsoft SQL Server and with the specified name. The trigger responds to the specified event set and runs the specified batch.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub New ( _
    parent As Server, _
    name As String, _
    events As ServerDdlTriggerEventSet, _
    assemblyName As String, _
    className As String, _
    method As String _
)
public ServerDdlTrigger (
    Server parent,
    string name,
    ServerDdlTriggerEventSet events,
    string assemblyName,
    string className,
    string method
)
public:
ServerDdlTrigger (
    Server^ parent, 
    String^ name, 
    ServerDdlTriggerEventSet^ events, 
    String^ assemblyName, 
    String^ className, 
    String^ method
)
public ServerDdlTrigger (
    Server parent, 
    String name, 
    ServerDdlTriggerEventSet events, 
    String assemblyName, 
    String className, 
    String method
)
public function ServerDdlTrigger (
    parent : Server, 
    name : String, 
    events : ServerDdlTriggerEventSet, 
    assemblyName : String, 
    className : String, 
    method : String
)

参数

  • name
    A String value that specifies the name of the server 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.

备注

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Create, Alter, and Remove a Trigger in Visual Basic .NET

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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

其他资源

Creating, Altering, and Removing Triggers
DDL 触发器
CREATE TRIGGER (Transact-SQL)