ReInitializeAllSubscriptions Method

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The ReInitializeAllSubscriptions method marks all subscriptions for reinitialization.

Syntaxe

object.ReInitializeAllSubscriptions()

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT ReInitializeAllSubscriptions();

Notes

Use the ReInitializeAllSubscriptions method only when the SQL Distributed Management Objects (SQL-DMO) object references a transactional or merge replication publication.

After using ReInitializeAllSubscriptions, it may be necessary to update the initial snapshot of the publication. When the transactional replication publication is configured for automatic synchronization (the PublicationAttributes property returns SQLDMOPubAttrib_ImmediateSync), the initial snapshot of the publication must be updated. For all other publication types, it is strongly suggested that the application force an update of the initial snapshot.

Reinitializing subscriptions to a publication by using the ReInitializeAllSubscriptions method requires appropriate privilege. The Microsoft SQL Server login used for SQLServer object connection must be a member of the fixed server role sysadmin or fixed database role db_owner in the database referenced by the publication.