Assembly and replication

Question

Hello,

I am using a transactional replication that replicates stored procedures which are implemented in a clr assembly. The assembly and procedures are successfully replicated to the subscribers and work fine at the subscribers. Unfortunately changes to the assembly are not replicated. So when I change the assembly with "ALTER ASSEMBLY FROM 0x45..." in the published database the new version is installed in the published database (and works). But the transactional replication does not care about the change and does not replicate it to the subscribers.

I tried to alter the procedures at the publisher with "ALTER PROCEDURE ..." which leads to a replicated ddl command but the assembly is still unchanged.

I also tried this with a merge replication with the same result. SQL Server version is 15.0.4223.1.

Has anyone any ideas?

Thanks & Best regards,
Michael

Answer 1

Hi @Michael Hirsch ,

If the assembly already exists, you cannot alter an assembly during synchronization

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

An alternative, if not very palatable is to drop the procedures and the assembly and then recreate them. Now, that requires that DROP ASSEMBLY is replicated....