Merge Replication

  • I have an application that I'm using merge repl.  At the publisher side I'm using an Access ODBC frontend to interface with the SQL backend and at the Subscriber side I have the same setup.  However, when I tell it to sync it returns a message that says " no data needed to be merged"  when clearly there is data to be merged.  The server sends me an email after completion of the job and it says,

    JOB RUN: 'DNRDIGJBORMAN-PAWSDOGISQL1-DOGFIELD-XPLAPDOGBEN-34'

    Where DNRDIGJBORMAN = PUBLISHER SERVER

    Where PAWSDOGISQL1 = PUBLISHER DATABASE

    Where DOGFIELD = PUBLICATION

    Where XPLAPDOGBEN = SUBSCRIBER SERVER

    But it never mentions the SUBSCRIBER DATABASE ?  Should it ? any help would be greatly appreciated......

     

  • No, the subscriber database doesn't appear in the job's name.

    Check the agent parameters to be sure that everything is ok.

    Also run sp like sp_helpmergepublication,

    sp_helpmergesubscription and sp_helpmergearticle to be sure everytinh is ok.

  • Thank you for your response!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply