Transaction Replication RRS feed

  • Question

  • Hi,

        How to get details of script which one get error in Subscriber.

    This Mean,

                Some data inserted successfully in Publisher but getting error in Subscriber,i Want know which statement get error in subscriber.




    Thursday, August 17, 2017 5:15 AM

All replies

  • USE distribution
    DECLARE @PublisherServer  VARCHAR(50),
            @PublicationDB    VARCHAR(50),
            @SubscriberServer VARCHAR(50),
            @SubscriberDB     VARCHAR(50),
            @PublicationName  VARCHAR(50)
    SET @PublisherServer = '<Publisher>'
    SET @PublicationDB = '<PublisherDB>'
    SET @SubscriberServer = '<Subscriber>'
    SET @SubscriberDB = '<SubscriberDB>'
    SET @PublicationName = '<Publication>'
    EXEC sp_helpsubscriptionerrors



    Mssql installation on Centos

    Thursday, August 17, 2017 4:33 PM
  • Thanks


    Saturday, August 19, 2017 11:28 AM
  • Hi chennai_svk,

    Could you please tell us if you have solved this problem? If it is, could you please mark Vishe's reply as Answered?

    Best Regards,


    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href=""></a>.

    Monday, August 21, 2017 2:31 AM
  • Hi,

    If you want to get exact command that is failing and throwing an error you should browse distribution db by using following proc. sp_browsereplcmds

    • Proposed as answer by philfactor Wednesday, August 23, 2017 1:05 PM
    Tuesday, August 22, 2017 12:01 PM