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…