Trigger.AssemblyName Property

Gets or sets the name of the .NET assembly that is required by the referenced trigger.

This API is not CLS-compliant. 

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

Syntax

'Declaration
<SfcReferenceAttribute(GetType(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Design)> _
Public Property AssemblyName As String 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As String 

value = instance.AssemblyName

instance.AssemblyName = value
[SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)]
public string AssemblyName { get; set; }
[SfcReferenceAttribute(typeof(SqlAssembly), L"Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Design)]
public:
property String^ AssemblyName {
    String^ get ();
    void set (String^ value);
}
[<SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)>]
member AssemblyName : string with get, set
function get AssemblyName () : String 
function set AssemblyName (value : String)

Property Value

Type: System.String
A String value that specifies the name of the assembly that is required by the referenced trigger.

Remarks

A value is required for the AssemblyName property only when the ImplementationType property is set to SqlClr.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)