In this blog post, let’s learn about the error message “22554 – Cannot change publication “%s” to use the sync_mode of “character” because it uses a retention period unit other than “day”. Use sp_changemergepublication to set the retention period unit to “day”.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
22554 – Cannot change publication “%s” to use the sync_mode of “character” because it uses a retention period unit other than “day”. Use sp_changemergepublication to set the retention period unit to “day”.
Reason for the Error
To be update soon…
Solution
To be update soon…