Posted by Benzine on 12/21/06 05:22

I recently setup merge replication and for each subscriber I add an try
and synchronize I get the following error message:

"The Process Could Not Log Conflict Information"

When I view the details of the error it states the following:

"The Process Could Not Log Conflict Information.
(Source: Merge Replication Provider (Agent); Error number: -2147200992)
---------------------------------------------------------------------------------------------------------
SELECT permissions denied on object 'conflict_mydatabase_mytable',
database 'MyDatabase', Owner 'MyUser'.
(Source: SERVERNAME(Data Source); Error number: 229)
---------------------------------------------------------------------------------------------------------
INSERT permissions denied on object 'conflict_mydatabase_mytable',
database 'MyDatabase', Owner 'MyUser'.
(Source: SERVERNAME(Data Source); Error number: 229)"

Judging from the Session Details it merges all data first but fails
right at the end with the above.

Can anyone help me with this??

PS. I had setup a test replication environment first and did not have
any problems, only once I put it into production I starting getting
these errors (My luck!)

[Back to original message]