SQL Server Error Msg 20697 – Cannot drop article %s from publication %s. In this publication, this is the only article that uses a parameterized filter. Dropping this article changes the publication to a static publication, which requires reinitialization of all Subscribers. To drop the article and reinitialize all active subscriptions, specify a value of 1 for the  @force_reinit_subscription parameter of sp_dropmergepublication.

In this blog post, let’s learn about the error message “20697 – Cannot drop article %s from publication %s. In this publication, this is the only article that uses a parameterized filter. Dropping this article changes the publication to a static publication, which requires reinitialization of all Subscribers. To drop the article and reinitialize all active subscriptions, specify a value of 1 for the  @force_reinit_subscription parameter of sp_dropmergepublication.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

20697 – Cannot drop article %s from publication %s. In this publication, this is the only article that uses a parameterized filter. Dropping this article changes the publication to a static publication, which requires reinitialization of all Subscribers. To drop the article and reinitialize all active subscriptions, specify a value of 1 for the  @force_reinit_subscription parameter of sp_dropmergepublication.

Reason for the Error

To be update soon…

Solution

To be update soon…