Please, I need some expert help. I´ll show you the trouble scenario:
I have a publiser and some subscriber to this plublisher.
This publisher publicate some articles that are filtered by the subscriber id, and other articles that are filtered by the other article id .
Article A - generic data
Article B - data restrict to each subscriber
Article A - select * from article_A where article_A_id in (select article_id from article_b where article_id = HOSTNAME)
Article B - select article_id from article_b where article_id = HOSTNAME
When it´s sincronized, only article B values are replicated to the subscriber, and the article_A values do not replicate. (if I do the select at the publisher database the roles are showed)
I have changed the processing_order property like are showed here http://msdn.microsoft.com/en-us/library/ms147310%28v=SQL.90%29.aspx , but the article_A values do not replicate.
Somebody already are passed for this situation, and can show me the light?
View Complete Post