I have a Merge Publication that is dynamically filtered based on HOST_NAME(). All subscriptions are push subscriptions (i.e all agents run in a common distributor)
In the definition of any Subscriber I can specify the value of HOST_NAME() for the pupose of dynamic filtering. But HOST_NAME() in the Post Snapshot script appears to be the actual HostName of the Distributor (not the HostName of the Subscriber
for whom that dynamic snapshot is intended).
How can I retrieve either the HOST_NAME for the subscriber as defined by the subscription, or the actual HOST_NAME() of the intended subscriber (either will do).
The processing performed by the Post Snapshot Script is conditional on which dynamic snapshot has just been invoked
View Complete Post