sp_reinitpullsubscription (T-SQL)

Marks a transactional pull or anonymous subscription for reinitialization the next time the Distribution Agent runs.

Syntax

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

Arguments

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

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_reinitpullsubscription is used in transactional replication.

sp_reinitpullsubscription can be called from the Subscriber to reinitialize the subscription, during the next run of the Distribution Agent. Note that the subscriptions of non_immediate_sync type publications cannot be reinitialized from the Subscriber.

You can reinitialize a pull subscription by either executing sp_reinitpullsubscription at the Subscriber or sp_reinitsubscription at the Publisher.

Permissions

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