Dynamic filter in Push Subscription

[mooki]

I need to replicate table to different subscribers according to specific field in that table.

I was using a Dynamic filter with the host_name() function which will work only for pull subscription.

Is there any way or any function that i could use in the "PUSH" so I will know who is the subscriber that is running it ?

thanx
Mooki.

 

[TomSark]

Yes, host_name() will return the name of the distributor in a push.

So... you could try to partition the data on the publisher side and push that partition to the subscriber. For example, create a table, put that subscribers data in the table, and push that data only to that particular subscriber...

Just a thought...

The only other way I can think of off the top of my head is to write a trigger on the subscriber that only applies the rows that you want for that subscriber... not the best solution, but it could work..
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com