sql server replication: I am trying to change from a Merge Pull subscription model to a Merge Push model. I have a filter on several articles so only data intended for a particular subscriber is sent to it. This is done like so: @subset_filterclause = N'Upper(TableName.TerminalID) = Upper(Host_Name())' . When I tested the push subscripton the wrong data went to the Subscriber, i.e. only data with the publisher's name went to the subscriber. With a push subscription how can I get only the data to the Subscriber. Obviously I can no longer use Host_Name() since it is now run at the publisher and uses its name instead the subscriber

Laurence
you can use -HOSTNAME as a parameter on the merge agent's job step. This is doubly useful because it can now be a business related detail rather than the computername in an extra column.
Regards