sys.sp_changesubscription

Description

Changes the properties of a snapshot or transactional push subscription or a pull subscription involved in queued updating transactional replication. To change properties of all other types sp_change_subscription_properties executed at the Publisher on the publication database.

Syntax

sp_changesubscription

Permissions

Only members of the fixed server role or fixed database role can execute. sp_addsubscription (Transact-SQL) sp_dropsubscription (Transact-SQL)