The database is not enabled for replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » The database is not enabled for replication -...

The database is not enabled for replication - when it seems it is

Rate Topic

Display Mode

Topic Options

Author

Message

mottya

Posted Thursday, February 28, 2013 2:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 11:59 AM
Points: 2, Visits: 16

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 »

Permissions