通过

DatabaseDdlTrigger.ExecutionContextUser 属性

  • 项目

Gets or sets the database user that is the context used when the database DDL trigger executes.

此 API 不符合 CLS。 

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcReferenceAttribute(GetType(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property ExecutionContextUser As String 
    Get 
    Set
用法
Dim instance As DatabaseDdlTrigger 
Dim value As String 

value = instance.ExecutionContextUser

instance.ExecutionContextUser = value

[SfcReferenceAttribute(typeof(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string ExecutionContextUser { get; set; }

[SfcReferenceAttribute(typeof(User), L"Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property String^ ExecutionContextUser {
    String^ get ();
    void set (String^ value);
}

[<SfcReferenceAttribute(typeof(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member ExecutionContextUser : string with get, set

function get ExecutionContextUser () : String 
function set ExecutionContextUser (value : String)

属性值

类型：System.String
A String value that specifies the database user that is the context used when the database DDL trigger executes.

注释

This property is required only when the ExecutionContext property is set to ExecuteAsUser.

示例

设置属性

请参阅

参考

DatabaseDdlTrigger 类

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

创建、更改和删除触发器

DDL 触发器

CREATE TRIGGER (Transact-SQL)