Share via

  • 發行項

ServerDdlTrigger 類別

The ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcElementTypeAttribute("DdlTrigger")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class ServerDdlTrigger _
    Inherits DdlTriggerBase
'用途
Dim instance As ServerDdlTrigger

[SfcElementTypeAttribute("DdlTrigger")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
public sealed class ServerDdlTrigger : DdlTriggerBase

[SfcElementTypeAttribute(L"DdlTrigger")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
public ref class ServerDdlTrigger sealed : public DdlTriggerBase

[<SealedAttribute>]
[<SfcElementTypeAttribute("DdlTrigger")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
type ServerDdlTrigger =  
    class
        inherit DdlTriggerBase
    end

public final class ServerDdlTrigger extends DdlTriggerBase

備註

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events.

SQL Server Management Objects (SMO) provides programmatic access to allow management of all DDL trigger functionality with the DatabaseDdlTrigger object and the ServerDdlTrigger object.

Database DDL triggers respond to events within the scope of the database and server DDL triggers respond to events within the scope of the SQL Server instance.

To get ServerDdlTrigger object properties, users can be a member of the public fixed server role.

To set ServerDdlTrigger object properties, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

To create or drop a server-level DDL trigger, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

Thread Safety

這種類型的任何公用靜態 (在 Microsoft Visual Basic 中則為 Shared) 成員都可用於多執行緒作業。並不是所有的執行個體成員都保證可以用於所有的執行緒。

執行緒安全性

這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。