Previous Topic: SQL Server Common FunctionalityNext Topic: SQL Server Browser for Functions, Script Templates, and Stored Procedures


Define SQL Server Assemblies

SQL Server assemblies contain metadata and managed code as an object in SQL Server. When you reference a SQL Server assembly you can create common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types in a SQL Server database.

Use the SQL Server Assembly Editor to define the properties for an assembly whose implementation is defined in a class of a .NET framework assembly in a 2008, 2012, 2014, or 2016 physical model.

To define a SQL Server assembly

  1. Click Target - SQL Server, Assemblies on the Model menu.

    The SQL Server Assembly Editor opens.

  2. Select the assembly in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new assembly. Use the Enter filter text box to filter a very large list of assemblies to quickly locate the one that you want to define.

    Name

    Specifies the name of the assembly. Change the name of the assembly in this field.

    Authorization

    Specifies the name of a user or role as the owner of the assembly. Make a selection from the drop-down or if no selection is made, SQL Server assumes the current user is the owner.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and work with the following options:
    Permission Set

    Specifies the code access permission granted to the assembly when it is accessed by SQL Server. Select the permission set from the drop-down.

    Visibility

    Specifies the visibility of the assembly. Select the visibility option from the drop-down.

    Unchecked Data

    Specifies to enable unchecked data for the assembly. Select the check box to specify unchecked data.

    Files

    Lists the assembly file names, location, and type. Select the check box for each file you want to include.

    Note: Click the Sort Items icon to rearrange the list, or click the File Editor icon to add a new file or edit an existing file in the SQL Server File Editor.

  4. Click the Permission tab to define the permissions for the assembly.
  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the Where Used tab to view where the object is used within the model.
  7. (Optional) Click the UDP tab to work with user-defined properties for the object.
  8. (Optional) Click the Notes tab to view and edit user notes.
  9. (Optional) Click the Extended Notes tab to view or edit user notes.
  10. Click Close.

    The assembly is defined and the SQL Server Assembly Editor closes.

More information:

Define Permissions for an Object in a SQL Server Property Editor

Define SQL Server Synonyms

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor