SQL Server Error Msg 20078 – The @property parameter value must be one of the following: ‘sync_type’, ‘priority’, ‘description’, ‘subscriber_security_mode’, ‘subscriber_login’, ‘subscriber_password’, ‘publisher_security_mode’, ‘publisher_login’, ‘publisher_password’, ‘merge_job_login’, or ‘merge_job_password’.

In this blog post, let’s learn about the error message “20078 – The @property parameter value must be one of the following: ‘sync_type’, ‘priority’, ‘description’, ‘subscriber_security_mode’, ‘subscriber_login’, ‘subscriber_password’, ‘publisher_security_mode’, ‘publisher_login’, ‘publisher_password’, ‘merge_job_login’, or ‘merge_job_password’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

20078 – The @property parameter value must be one of the following: ‘sync_type’, ‘priority’, ‘description’, ‘subscriber_security_mode’, ‘subscriber_login’, ‘subscriber_password’, ‘publisher_security_mode’, ‘publisher_login’, ‘publisher_password’, ‘merge_job_login’, or ‘merge_job_password’.

Reason for the Error

To be update soon…

Solution

To be update soon…