sp_changesubscription Replication Stored Procedure

Changes the subscription properties for an article or a publication. Is executed on a subscription server.

Syntax

sp_changesubscription publication, article, subscriber [, 'property', 'value']

where

publication

Is the name of the publication containing the article.

article

Is the name of the article.

subscriber

Is the name of the subscription server. If subscriber is not specified, defaults to @@REMSERVER (the server name contained within a remote server's login record).

property

Is the property to set. Can be sync_type or dest_db.

value

Is the value of property. For sync_type, can be none, manual, or automatic. For dest_db, is the name of a destination database.

Example

This example changes the subscription property of the myart3 article to a synchronization type of manual.

sp_changesubscription mypub1, myart3, sync_type, manual

Permission

Execute permission defaults to the system administrator and the database owner.

Tables Used

sysarticles, syspublications, syssubscriptions, sysservers

See Also