SQL Server Error Msg 22578 – Cannot change publication “%s” to disallow use_partition_groups because it contains one or more logical record relationships. When using logical record relationships the publication must set the @use_partition_groups property to ‘true’.

In this blog post, let’s learn about the error message “22578 – Cannot change publication “%s” to disallow use_partition_groups because it contains one or more logical record relationships. When using logical record relationships the publication must set the @use_partition_groups property to ‘true’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

22578 – Cannot change publication “%s” to disallow use_partition_groups because it contains one or more logical record relationships. When using logical record relationships the publication must set the @use_partition_groups property to ‘true’.

Reason for the Error

To be update soon…

Solution

To be update soon…