Replicating twice

I have a question that google seems eerily quite on. I'm running SQL
2005 and am replicating (merge via the web) from an intermediate box
which is also running 05. The intermediate box is replicating in some
fashion (unsure since it isn't under my control) from a SQL 2K box.
My issue is that when the job executes it says "Merge completed with no
data changes processed." even though the intermediate box has updated
data on it. Is this common? Is the answer so obvious that everyone is
laughing at me now?
Thanks
Jeremiah
It should work. How is your global priority configured? You might want to
check the conflict viewer to see if these conflicts are logged.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
>I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>
|||Jeremiah,
If I understand correctly, your SQL 2005 is subscribing from an intermediate
box, which subscribes from a SQL 2K server? Please note that for merge
replication, the publisher database version has be to newer than the
subscriber version, so basically SQL Server 2005 cannot be a subscriber of a
SQL 2000 publisher.
Yi Chen
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
>I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>
|||Are there any filters on the publisher that make the data not qualify for
the subscriber?
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"JC" <jbzcooper@.gmail.com> wrote in message
news:1141343267.632060.296050@.u72g2000cwu.googlegr oups.com...
> I have a question that google seems eerily quite on. I'm running SQL
> 2005 and am replicating (merge via the web) from an intermediate box
> which is also running 05. The intermediate box is replicating in some
> fashion (unsure since it isn't under my control) from a SQL 2K box.
> My issue is that when the job executes it says "Merge completed with no
> data changes processed." even though the intermediate box has updated
> data on it. Is this common? Is the answer so obvious that everyone is
> laughing at me now?
> Thanks
> Jeremiah
>