SQL Server Error Msg 22807 – The publication property ‘%s’ cannot be modified because the peer-to-peer publication ‘%s’ is not enabled for conflict detection. To enable the publication for conflict detection, use sp_configure_peerconflictdetection.

In this blog post, let’s learn about the error message “22807 – The publication property ‘%s’ cannot be modified because the peer-to-peer publication ‘%s’ is not enabled for conflict detection. To enable the publication for conflict detection, use sp_configure_peerconflictdetection.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

22807 – The publication property ‘%s’ cannot be modified because the peer-to-peer publication ‘%s’ is not enabled for conflict detection. To enable the publication for conflict detection, use sp_configure_peerconflictdetection.

Reason for the Error

To be update soon…

Solution

To be update soon…