locked
SQL Server Replication Error occured during the new article addtion RRS feed

  • Question

  • HI All,

    We are facing the Sql Server Replication error during the new article addition.

    Msg 20027, Level 11, State 1, Procedure sp_MSadd_subscription, Line 223
    The article '(null)' does not exist.
    Msg 14070, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1208
    Could not update the distribution database subscription table. The subscription status could not be changed.
    Msg 14057, Level 16, State 1, Procedure sp_MSrepl_addsubscription_article, Line 383
    The subscription could not be created.
    Msg 266, Level 16, State 2, Procedure sp_MSrepl_addsubscription, Line 0
    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
    Msg 266, Level 16, State 2, Procedure sp_addsubscription, Line 0
    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 

    Please help us to fix the error.

    Regards,

    Pawan Singh


    Thanks

    Thursday, March 27, 2014 12:29 PM

All replies