SQL Server Error Msg 21579 – Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in multiple join filters. Either select a value of 0 or 1 for the @partition_options parameter, or drop all but one of the join filters by using sp_dropmergefilter.

In this blog post, let’s learn about the error message “21579 – Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in multiple join filters. Either select a value of 0 or 1 for the @partition_options parameter, or drop all but one of the join filters by using sp_dropmergefilter.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21579 – Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in multiple join filters. Either select a value of 0 or 1 for the @partition_options parameter, or drop all but one of the join filters by using sp_dropmergefilter.

Reason for the Error

To be update soon…

Solution

To be update soon…