Sp with an sql assembly

Running a storedprocedure from coldfusion 10 and sql2014.

Question is related to the stored procedure  with an assembly calling in it.The assembly is used to create a xml file.

<span;>Made a very minor change in the dateadd function of sp and executed the alter sp Again.

<span;>Now the assembly part is not working after making changes.
<span;>Do we need to  do any additional process
<span;>to work the assembly as before?
<span;>Please advise