SQL Server Error Msg 21729 – The @keep_partition_changes property cannot be set to “true.” This is because the @publication_compatibility_level property is set to 90RTM or higher and the @use_partition_groups property is set to “true.” Set a lower compatibility level or set the @use_partition_groups property to “false.”

In this blog post, let’s learn about the error message “21729 – The @keep_partition_changes property cannot be set to “true.” This is because the @publication_compatibility_level property is set to 90RTM or higher and the @use_partition_groups property is set to “true.” Set a lower compatibility level or set the @use_partition_groups property to “false.”” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21729 – The @keep_partition_changes property cannot be set to “true.” This is because the @publication_compatibility_level property is set to 90RTM or higher and the @use_partition_groups property is set to “true.” Set a lower compatibility level or set the @use_partition_groups property to “false.”

Reason for the Error

To be update soon…

Solution

To be update soon…