Script level upgrade for master database failed

  In this post I would like to explain one of the interesting issues that I encountered while upgrading a SQL Server Instance. Symptoms · SQL Server instance is upgraded using a service pack or any other update. · After the upgrade SQL server service starts but it stops in next few seconds. · When…

0

Merge Replication: Expired Subscription Clean Up Job / sp_expired_subscription_cleanup / sp_MScleanup_conflict fails with error Msg 1934, Level 16, State 1 AND Msg 20709, Level 16, State 1, Procedure sp_MScleanup_conflict…??

  Issue: If you have a Merge Replication, you may encounter the below error message thrown by Expired Subscription Cleanup job (sp_expired_subscription_cleanup) with a mention of conflict table of an article for the publication as below: Msg 1934, Level 16, State 1, Line 1 DELETE failed because the following SET options have incorrect settings: ‘ANSI_NULLS,…

0