I thought I would be able to apply different horizontal filters in different
publications to the same articles but when I try and do this I get an error
message. I can't understand how this filtering is useful if you can't use it
to partition different data to each subscriber.

I can define a view on the partition and create a publication including that
as an article but this seems a bit rubbish.

Am I missing the point?

Regards,

You can also use suser_name() which can be overridden by the publisherlogin
command line parameter for your merge agent. Also note that the value of
Host_Name() can be overridden by the -HostName command line parameter for
your merge agent.

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



[quoted text, click to view]

The same horizontal partition is used, but HOST_NAME() can be used in the
where clause to make it dynamic - different for each subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com