SQL Server Error Msg 21372 – Cannot drop filter ‘%s’ from publication ‘%s’ because its snapshot has been run and this publication could have active subscriptions. Set @force_reinit_subscription to 1 to reinitialize all subscriptions and drop the filter.

In this blog post, let’s learn about the error message “21372 – Cannot drop filter ‘%s’ from publication ‘%s’ because its snapshot has been run and this publication could have active subscriptions. Set @force_reinit_subscription to 1 to reinitialize all subscriptions and drop the filter.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21372 – Cannot drop filter ‘%s’ from publication ‘%s’ because its snapshot has been run and this publication could have active subscriptions. Set @force_reinit_subscription to 1 to reinitialize all subscriptions and drop the filter.

Reason for the Error

To be update soon…

Solution

To be update soon…