Does @partition_options Apply to the Whole Filter Hierarchy
-
Thursday, November 29, 2012 9:17 PM
When I look here,
http://msdn.microsoft.com/en-us/library/ms151226(v=sql.105).aspx
It talks about using the @partition_options parameter on the sp_addmergearticle. If a value of 3 (The filtering yields values that are unigue for each subscription) is set on of the top tables in the filter hierarchy, does it apply to the child tables too?
For instance if my hierarchy looks like this,
ParentTable -> ChildTable
Is it possible to set a value of 3 for the ParentTable (each row only goes to one subscriber), and a value of 0 for ChildTable (each row can go to multiple subscribers)?
.png)
