I'm running replication on a SQL 2008 server. I have a couple of Push Subscriptions.
The IP address for one of my subscribers changed. Eg. (10.10.132.16 to 10.10.132.17)
Previously I've used sp_changesubscription
to change properties like subscriber_login
and subscriber_password
on the subscription.
However the actual subscriber is not one of the properties you can change.
Is there any way to alter the subscriber, without dropping and re-creating the subscription?
When trying to do it through Management Studio, the subscriber fields are greyed out and doesn't allow me to change it.