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
)

매개 변수

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

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

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

• 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)