sp_reinitmergepullsubscription (T-SQL)

Marks a merge pull subscription for reinitialization the next time the Merge Agent runs.

Syntax

sp_reinitmergepullsubscription [[@publisher =] 'publisher']
[,[@publisher_db =] 'publisher_db'] [,[@publication =] 'publication']

Arguments

[@publisher =] 'publisher': Is the name of the Publisher. publisher is sysname, with a default of all.
[@publisher_db =] 'publisher_db': Is the name of the Publisher database. publisher_db is sysname, with a default of all.
[@publication =] 'publication': Is the name of the publication. publication is sysname, with a default of all.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_reinitmergepullsubscription is used in merge replication.

sp_reinitmergepullsubscription can be called from the Subscriber.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_reinitmergepullsubscription.