SQL Server Error Msg 14822 – ‘%s’ is not a valid option for the @mode parameter. Enter  ‘ALL’, ‘LOCAL_ONLY’ or ‘REMOTE_ONLY’.

In this blog post, let’s learn about the error message “14822 – ‘%s’ is not a valid option for the @mode parameter. Enter  ‘ALL’, ‘LOCAL_ONLY’ or ‘REMOTE_ONLY’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

14822 – ‘%s’ is not a valid option for the @mode parameter. Enter  ‘ALL’, ‘LOCAL_ONLY’ or ‘REMOTE_ONLY’.

Reason for the Error

To be update soon…

Solution

To be update soon…