Error in Merge Replication_compensate_for_errors -- sql server replication

Vikas
8/7/2006 8:28:02 AM

Hi all,

When i run the script for merge replication (adding article): exec
sp_addmergearticle @publication = N'TestPublication', @article =
N'TestTable' , @source_owner = N'dbo', @source_object = N'TestTable' ,
@type = N'table' , @description = null, @creation_script = null,
@pre_creation_cmd = N'delete', @schema_option = 0x0000000030034EA1,
@identityrangemanagementoption = N'none', @force_reinit_subscription = 1,
@column_tracking = N'true', @subset_filterclause = N'[StoreID] =
HOST_NAME()', @vertical_partition = N'false', @verify_resolver_signature = 1,
@allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true',
@check_permissions = 0, @subscriber_upload_options = 0, @delete_tracking =
N'true', @compensate_for_errors = N'false', @stream_blob_columns = N'false',
@partition_options = 0

I get the following error message (i have 10 scripts for 10 tables and for
every table this error message appears). Please help in this

Publication 'TestPublication' has the following property:
'compensate_for_errors'. SQL Server subscribers below version '8.00.0858'
will ignore this setting.

Cheers

Vikas
8/7/2006 10:59:49 AM

Hi paul,

But iam using SQL Server 2005, are you sure that we can install this
hotfix for SQL Server 2005?

[quoted text, click to view]

Paul Ibison
8/7/2006 5:32:42 PM

Vikas - this was a hotfix incorporated into SP4 (see
http://support.microsoft.com/kb/828637). The message is saying that if you
have subscribers below this version/hotfix, then it won't work.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Paul Ibison
8/7/2006 7:59:05 PM

Vikas,
my guess is that this is merely a warning message for those cases where the
subscriber is SQL Server 2000 - in case it is an earlier service pack
version.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Vikas
8/8/2006 2:17:35 AM

Hi paul,

Yes, iam using SQL Server 2000 for subscriber and SQL Server 2005
for Publisher. the message appears at publisher. So, you say that i can
continue with this as it is only a warning message. right?

Thanks

[quoted text, click to view]

Vikas
8/8/2006 10:01:02 AM

Thank you for early response.

[quoted text, click to view]

Paul Ibison
8/8/2006 10:29:19 AM

Vikas,
provided you have sp4 on the subscriber, or sp3 and the hotfix, I would say
you're fine. My guess is that a lower version will also be ok but will
simply ignore the parameter.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Error in Merge Replication_compensate_for_errors