views:

116

answers:

0

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.