I am using Merge Replication on a few SQL Server 2008 R2 servers. There is one server, and the rest are clients.
I have each of the clients on a different partition using row filters with the
This works as expected, but I can't seem to figure out how to change this value after creating the subscription.
I need to change this value for all of the subscriptions and I would like to avoid dropping and recreating them.
How can I change the
HOST_NAME() value for a subscriber without dropping/recreating?