ServerDdlTrigger Constructor (Server, String, ServerDdlTriggerEventSet, String)

Initializes a new instance of the ServerDdlTrigger class on the specified database 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, _
    textBody As String _
)

public ServerDdlTrigger (
    Server parent,
    string name,
    ServerDdlTriggerEventSet events,
    string textBody
)

public:
ServerDdlTrigger (
    Server^ parent, 
    String^ name, 
    ServerDdlTriggerEventSet^ events, 
    String^ textBody
)

public ServerDdlTrigger (
    Server parent, 
    String name, 
    ServerDdlTriggerEventSet events, 
    String textBody
)

public function ServerDdlTrigger (
    parent : Server, 
    name : String, 
    events : ServerDdlTriggerEventSet, 
    textBody : 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 trigger responds.

• textBody
  A String value that specifies the Transact-SQL batch statement that runs when the trigger has been 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)