Merge replication - SQL2005 but DB in 2000 compatible mode - 05-20-2009 , 07:47 AM
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 ?
- 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
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
- 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
RE: Merge replication - SQL2005 but DB in 2000 compatible mode - 05-21-2009 , 03:13 AM
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?