Groups | Blog | Home
all groups > sql server replication > june 2006 >

sql server replication : Transactional with queued updating replication-problem



jane doe
6/12/2006 11:20:44 PM
Hello,
I studied Transactional with queued updating replication. But I've the
problem now.
The Problem is Replication fails with Error 208 "
Error 208: Invalid object name 'object_name'.
Unable to replicate a view or function because the referenced objects
or columns are not present on the Subscriber. " BUG number is 234529
(SHILOH_BUGS) .

This behavior may also occur when you add the referenced table to the
merge publication after you add the schema only article, and after
generating an initial snapshot for the publication.

I always search in Internet. But there is no solution.
Could you advise me about the error code 208?
thanks for all
Paul Ibison
6/16/2006 7:46:14 PM
Jane,
I would recommend placing the programming objects in a separate publication,
as they don't really follow the normal business rules for data modification
and reinitializing has a different meaning. If you do this, the programming
objects should be able to be replicated after the initialization of the data
publication and it'll work ok. If however the issue regards a false
dependency between programming objects eg views, then this is a different
matter. Refreshing the view usually sorts out incorrect dependency info
though.
[quoted text, click to view]
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button