Add function to existing CLR assembly?

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  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
  

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  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