Cannot propagate the constraint changes to subscriber in merge replication
Posted on 2005-05-09
I have been using merge replication with pull subscription. I managed to add a constraint using the following steps and schema changes were taken place at the publisher, but when i do syncronization at the subscriber, it does not sync,instead it gives en error. I have even re-initialized the subscription, still it does not work. Is anyone out there to give me a solution.
Your help would really be appreciated. Thanks in advance.
steps, that i have used to create a constraint on the published table is given below.
a. Open Notepad
b. Paste the following Transact – SQL Command
alter table <PublishedTableName>
add constraint <ConstraintName>
c.Save the files as addConstraint.sql
d. use <PublicationDatabase>
sp_addscriptexec @publication = <PublicationDatabase>,
@scriptfile = <path of addConstraint.sql>
Error that i have encountered at the subscriber when i syncronize is given below
The schema script '0\\machinename\repldata\20050506184002630\addConstraint.sql could not propagate