Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The database is not enabled for replication - when it seems it is Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 2:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:03 AM
Points: 2, Visits: 42
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.
Post #1425279
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse