Posted by ho.horace@gmail.com on 09/24/07 01:49

Dear All,
I am using SQL 2005 as pub and SQL EXPRESS as sub with Merge
replication. Got
the following error message

The schema script 'CD_InTransit_v_153.sch' could not be propagated to
the
subscriber.
Error Detail:
The schema script 'CD_InTransit_v_153.sch' could not be propagated to
the
subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
Unable to replicate a view or function because the referenced objects
or
columns are not present on the Subscriber. (Source: MSSQL_REPL, Error
number:
MSSQL_REPL20164)
Get help: http://help/MSSQL_REPL20164
Invalid object name 'dbo.Debit_v'. (Source: MSSQLServer, Error number:
208)
Get help: http://help/208

According to error message, it seems that debit_v is missing. However,
I
cannot control the sequence of view to replicate. How can I solve this
problem

I think that problem is coming from the nested view (a view that
references
a view). I tried transactional with update which doesn't any gives
error at
all. However, error happen in merge replication for the first
snapshot...
Please help..

• Next in forum: Re: PHP code to Stored Procedure
• Prev in forum: Re: Retrieve ONLY first/max
• Thread view: Merge Replication nested view replication problem

[Reply to this message]