none
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.

    Thanks,

    Vinoth


    Vinoth

    Thursday, August 17, 2017 5:15 AM

All replies

  • USE distribution
    GO
     
    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
      @PublisherServer,
      @PublicationDB,
      @PublicationName,
      @SubscriberServer,

      @SubscriberDB

    refer

    http://www.sqlideas.com/2015/05/script-to-get-transactional-replication.html


    Mssql installation on Centos

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

    Vinoth

    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,

    Teige


    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="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    Monday, August 21, 2017 2:31 AM
    Moderator
  • 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

    https://bartoszlewandowski.blog/2017/08/08/how-to-browse-distributor-sp_browsereplcmds-explained/

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