Asked by: migav
I have a merge replication between 2 sql servers 2005 sp3 that goes up and down.
I get the following error messages:
The schema script 'if object_id(N'[dbo].[Companies]') is not null exec('ALTER TABLE [dbo].[Companies] ADD CONSTRAINT DF_Companies_uuES DEFAULT (0) FOR uuES ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: http://help/MSSQL_REPL-2147201001
Column already has a DEFAULT bound to it. (Source: MSSQLServer, Error number: 1781) Get help: http://help/1781 Could not create constraint.
See previous errors. (Source: MSSQLServer, Error number: 1750) Get help: http://help/1750
Attached the tables structure.
I took the following actions :
1- On subscriber I backuped the contraints with create to the clipboard.
2- On subscriber I deleted the contraints.
3- On publisher I re-initialized the subscription with create a new snapshot.
I can observe :
- Only 1 constraint propagate to the subscriber - the uuES the same on error message.
- I get the same error message afer the snapshot has finished.
- The sincronization is flapping, goes up and down.