June 20, 2014 at 2:17 am
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
June 20, 2014 at 2:41 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply