Conflict Resolutor Error

For Spanish version visit this link Error Resolutor de Conflictos
 
We found an error in Merge replication that im going to describe:
 
When a Subscriber SQL Server 2005 Express replicates against a Publisher SQL Server 2008 R2 with a publication that has filtered articles, the option use_partition_groups set to true and contains an article with a conflict resolutor different at default, the following error occurs:
 
The process could not initialize ‘Microsoft SQLServer Stored Procedure Resolver’. Verify that the component is registered correctly
 
We tried to upgrade SQL Server 2008 R2 to SP1 CU2, it is the last version come out, as well as this we has been proven to raise SQL Server 2005 Express to SP4 CU3 and error continues.
The error doesn’t occur if the Subscriber is SQL Server 2008 R2 RTM.
 
It has been reported to Microsoft and have recognized that it is a bug, which is fixed in Denali, but so far no date for the fix in 2008 R2.

About Fran Lens
SQL Server Analyst at Avanade Spain http://www.lensql.net

One Response to Conflict Resolutor Error

  1. Pingback: Error Resolutor de Conflictos « LenSQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: