sp_addmergearticle "invalid object name" sysarticleupdates

• Shurgenz

  SSC Eights!

  Points: 802

  More actions

  June 20, 2014 at 2:17 am

  #287845

  Hello all

  I am trying to create merge replication. the replication is created after the steps:

  1. sp_replicationdboption

  2. sp_addmergepublication

  3. sp_addpublication_snapshot

  but fails on sp_addmergearticle with the error above.

  several times I ve recreated the replication by sp_removedbreplication and repeating the steps 1-3. Ive looked and did not find the table sysarticleupdates in system tables for the DB.

  I've found in internet an advise to update [master].[dbo].[sysobjects]. As the sp sp_addmergearticle could be corrupted. But updates on system tables don't allowed in MSSQL 2008 R2

  thank You in advance

• Shurgenz

  SSC Eights!

  Points: 802

  More actions

  June 20, 2014 at 2:41 am

  #1723493

  i've found an issue

  exec sp_replicationdboption @dbname = @_dbname, @optname = N'merge publish', @value = N'true' was not enough for the merge replica

  in addition it needs to run

  exec sp_replicationdboption @dbname = @_dbname, @optname = N'publish', @value = N'true' not sure why it is needed for merge replica. But finally the sp_addmergearticle executed without errors