Assume that you create a merge publication in Microsoft SQL Server 2016 and 2017. When you try to encrypt a stored procedure that's not part of the published objects by using the ALTER PROCEDURE … WITH ENCRYPTION statement, you may notice that the statement fails with an error message that resembles the following:
Msg 536, Level 16, State 4, Procedure ProcedureName, Line LineNumber [Batch Start Line LineNumber]
Invalid length parameter passed to the RIGHT function.
This issue is fixed in the following cumulative updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminologythat Microsoft uses to describe software updates.