sp_changesubscription for changing subscriber password

For DBA its a routine activity to change server passwords.
If we are using replication between servers and if we are changing password of subscribers
we have to change it on publisher also.

we can use sp_changesubscription here to change password for the subscriber.

We can use it for changes the properties of a snapshot or transactional push subscription or a pull subscription involved in queued updating transactional replication

Popular Posts