Online Documentation for SQL Manager for SQL server

Creating/editing assembly


Use the Assembly tab of Assembly Editor to create/edit an assembly and specify its properties.

 

Name

Enter a name for the new assembly, or view the name of the assembly being edited.

 

Owner

Use the drop-down list to select the owner of the assembly (the name of a database user or role).

 

Assembly Editor - Editing assembly definition

 

 

CheckBox Visible for creating CLR objects

This option specifies whether the assembly is visible for creating common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types against it. If disabled, the assembly is intended to be called only by other assemblies. If there are existing CLR database objects already created against the assembly, the visibility of the assembly cannot be changed.

 

CheckBox Don't check data that depends on assembly

If this option is unchecked, SQL Server refreshes even those assemblies upon which persisted data in the database is dependent.

 

 

Code access permissions

Specifies a set of code access permissions granted to the assembly when it is accessed by SQL Server.

 

RadioButton Safe

The most restrictive permission set. Code executed by an assembly cannot access external system resources such as files, the network, environment variables, or the registry.

 

RadioButton External access

Allows assemblies to access certain external system resources such as files, networks, environmental variables, and the registry.

 

RadioButton Unsafe

Allows assemblies unrestricted access to resources, both within and outside SQL Server. Code executing from within an Unsafe assembly can call unmanaged code.

 

The Assembly info panel is used to display information about the assembly or application, including a description, version information, company name, product name, and more. This information corresponds to the values of global assembly attributes.

 

The Files list allows you to manage files that correspond to the assembly, and specify the local path or network location.

 

To add a file, right-click within the Files area and select the iconPlus Add Row popup menu item.

To remove a file, right-click the file name within the Files area and select the iconMinus Delete Row popup menu item.