Merge Replication

• markwnorsoft

  SSC Eights!

  Points: 827

  More actions

  May 3, 2004 at 9:27 am

  #85312

  Hi,

   

  What I have is win2000 sp4 and SQL 2000 sp3.  The only thing that changed was I installed sp3 5 days ago.

  I get this when Replication runs. 

   

  Last Command

  {call sp_mergemetadataretentioncleanup(?, ?, ?)}

   

  Error Message

  The merge process could not perform retention-based meta data cleanup in database 'Data1'.

   

  Error Detail

  The merge process could not perform retention-based meta data cleanup in database 'Data1'.

  (Source: Merge Replication Provider (Agent); Error number: -2147199467)

  ---------------------------------------------------------------------------------------------------------------

  Invalid column name 'maxversion_at_cleanup'.

  (Source: NT1DB (Data source); Error number: 207)

   

  Any ideas?

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 6, 2004 at 7:31 am

  #505473

  Are all the subscribers, publishers and distributor of your replication schema with the same service Pack?

  Check in the SP3 documentation (in microsoft) for the correct order to apply service packs.