Post reply

Add function to existing CLR assembly?

  • April 7, 2017 at 4:14 pm

    #336794

    I have an existing CLR assembly with multiple utility functions, and I want to add a new one. Is this possible? I tried ALTER ASSEMBLY with binary bits, but it does not show the new assembly_method in sys.assembly_modules. If I create the assembly, it works great. Is it possible to add a new function, or do I need to create a new assembly?

    Have Fun!
    Ronzo

  • April 7, 2017 at 9:18 pm

    #1937301

    You can definitely add a new method to an existing assembly. Altering the assembly will not automatically change the results of sys.assembly_modules. You also need to compile the complementary T-SQL object that passes off to your new assembly method before it will show up.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply