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



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


xSQL.SchemaCompare.SqlServer Namespace



┬ęCopyright 2022 xSQL Software. All Rights Reserved.

Send Feedback