In this blog post, let’s learn about the error message “21578 – In order to use partition_options of 2 (non overlapping partitions with multiple subscriptions per partition) or 3 (non overlapping partitions one subscription per partition) the publication ‘%s’ must be enabled to use partition groups functionality. Use sp_changemergepublication to set ‘use_partition_groups’ to ‘true’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21578 – In order to use partition_options of 2 (non overlapping partitions with multiple subscriptions per partition) or 3 (non overlapping partitions one subscription per partition) the publication ‘%s’ must be enabled to use partition groups functionality. Use sp_changemergepublication to set ‘use_partition_groups’ to ‘true’.
Reason for the Error
To be update soon…
Solution
To be update soon…