hi
I have a database that I know is enabled for merge replication because i have another merge replication on it.
and.. when i run the following:
use master
exec sp_replicationdboption @dbname = N'Digital', @optname = N'merge publish', @value = N'true'
GO
yet when i try the following :
use [Digital]
exec sp_addarticle @publication = N'DefaultPublication', @article = N'accs', @source_owner = N'dbo', @source_object = N'accs', @type = N'logbased', @description = null, @creation_script = null, @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509F, @identityrangemanagementoption = N'manual', @destination_table = N'accs', @destination_owner = N'dbo', @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_dboaccs', @del_cmd = N'CALL sp_MSdel_dboaccs', @upd_cmd = N'SCALL sp_MSupd_dboaccs'
GO
I get the following error:
The replication option 'merge publish' of database 'Digital' has already been set to true.