Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Constraints replication

Author  Topic 

svicky9
Posting Yak Master

232 Posts

Posted - 2007-10-18 : 04:59:58
Hi Experts

we have a merge replication in place between 2 databases.

User A has created a constraint between a replicated table "R" and the non replicated "NR"

And the replication started failing

The error comes up like 'the Schema Script could not be propagated to the Subscriber'

i tried deleting the constraint but the replication still fails

Should i remove the schema script

Vic

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-19 : 23:45:09
What kind of constraint? Specified not for replication when create it?
Go to Top of Page
   

- Advertisement -