AssemblyCreateOptionEnum Enumeration

Defines constants that determine the additional action that should be performed in a database when a new assembly is created. Changes in the assembly registration policy, introduced in SQL Server 2017, require these additional actions in order to successfully register the assembly.

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
Public Enum AssemblyCreateOptionEnum 
   Inherits System.Enum

public enum AssemblyCreateOptionEnum : System.Enum

__value public enum AssemblyCreateOptionEnum : public System.Enum

Members

Member	Description
AddAssemblyToTrustedList	Generate a script that adds the new assembly to the SQL Server trusted list.
DisableClrStrictSecurity	Generates a script that disables the "CLR strict security" option before creating the assembly. The option remains disabled after the script completes.
None	No action additional action is required.
SetTrustworthyOptionOn	Generates the script that sets the TRUSTWORTHY option ON, before creating the assembly.

Remarks

The actions described here do not replace the CREATE ASSEMBLY statement. They change databases settings or add additional statements, usually before the assembly is created, so that the CLR assembly is not rejected by SQL Server. They effect only databases on SQL Server 2017 or higher.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         xSQL.SchemaCompare.SqlServer.AssemblyCreateOptionEnum

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

xSQL.SchemaCompare.SqlServer Namespace