Hi

My application uses *= and =* as outter join, so, I had to create my db in
SQL 2000 Compatible Mode, in order to run this application.

But a question: The merge replication should work fine on Sql2005 using
Sql2000 Compatible mode ?

Scenario:
- Using SQL 2000 my merge replication works great
- Using SQL 2005 with 2000 compatible mode, the merge replication is running
but with errors:

"A row update at 'H1P.BD_SOFTLAB_P00' could not be propagated to
'H7.BD_SOFTLAB_P02'.
This failure can be caused by a constraint violation.
The Merge Agent was unable to synchronize the row due to one or more
unanticipated errors in the batch of changes.
When troubleshooting, increase the -OutputVerboseLevel setting, restart the
agent, and check for and resolve any errors generated by the database
engine. "

Considerations:
- all the referenced data exists (there is no reason to FK error)
- all SPs are instaled
- I had googled for the solution off this error, but nothing found.

Any Idea ?

thanks in advance

Wilker

I've never tried this configuration and there's no documentation I know of
that explains if this is supported. What happens if you increase
-OutputVerboseLevel and log to a file - get any more useful info?
Cheers,
Paul Ibison