dbTalk Databases Forums  

Merge Replication nested view replication problem

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Merge Replication nested view replication problem in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ho.horace@gmail.com
 
Posts: n/a

Default Merge Replication nested view replication problem - 09-23-2007 , 08:49 PM






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..


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.