Unanswered: Replication Of Views That Reference Other Views
i am getting this error in Merge Replication using Sql Server 2005
The schema script 'VW1_1452.sch' could not be propagated to the subscriber. Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.
Invalid object name VW2'.
I think the error occurs, because VW2 is not yet present on the subscriber when the agent tries to create VW1. (when i check the views created on the subscriber after the agent fails, VW2 is missing)
so how can I tell the agent the order of creating objects?
or is there any other solution?