xSQL Schema Compare SDK version 11 for SQL Server
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
'Declaration
 
Public Enum AssemblyCreateOptionEnum 
   Inherits System.Enum
public enum AssemblyCreateOptionEnum : System.Enum 
__value public enum AssemblyCreateOptionEnum : public System.Enum 
Members
MemberDescription
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

See Also

Reference

xSQL.SchemaCompare.SqlServer Namespace

 

 


┬ęCopyright 2019 xSQL Software. All Rights Reserved.

Send Feedback