October 4, 2012 at 6:57 am
Asked by: migav
Hi!
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.
Migav.
October 23, 2012 at 3:29 am
It looks like you are attempting to add the constraint each time that the synchronisation runs. As it already exists, the script returns a failure result. You should check for the existence of the constraint in your schema script.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply