Share via

ServerDdlTrigger.ExecutionContext Property

  • Article

Gets or sets the execution context type used by server DDL trigger, itself, the caller, or a specified login.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property ExecutionContext As ServerDdlTriggerExecutionContext 
    Get 
    Set
'Usage
Dim instance As ServerDdlTrigger 
Dim value As ServerDdlTriggerExecutionContext 

value = instance.ExecutionContext

instance.ExecutionContext = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public ServerDdlTriggerExecutionContext ExecutionContext { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property ServerDdlTriggerExecutionContext ExecutionContext {
    ServerDdlTriggerExecutionContext get ();
    void set (ServerDdlTriggerExecutionContext value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member ExecutionContext : ServerDdlTriggerExecutionContext with get, set

function get ExecutionContext () : ServerDdlTriggerExecutionContext 
function set ExecutionContext (value : ServerDdlTriggerExecutionContext)

Property Value

Type: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerExecutionContext
A ServerDdlTriggerExecutionContext object that specifies the type of execution context used by the server DDL trigger.

Remarks

If you specify that the execution context type is ExecuteAsLogin then you must also set the ExecutionContextLogin property to specify which login to use.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

ServerDdlTrigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DDL Triggers

CREATE TRIGGER (Transact-SQL)