ReInitialize2 Method

SQL-DMO

SQL-DMO

ReInitialize2 Method

The ReInitialize2 method marks a subscription for reinitialization.

Applies To
MergePublication2 Object MergeSubscription2 Object
MergePullSubscription2 Object  
Syntax

object.ReInitialize2( [ bUploadFirst ] )

Parts

object

Expression that evaluates to an object in the Applies To list

bUploadFirst

Optional Boolean that specifies whether to upload all changes from the Subscriber prior to applying the updated snapshot files when reinitializing a subscription.

Prototype (C/C++)

HRESULT ReInitialize2(BOOL bUploadFirst);

Remarks

Call ReInitialize2 with bUploadFirst set to TRUE to reinitialize a merge subscription, thereby preserving any changes made at the Subscriber since the last synchronization. This optional syntax directs the Merge Agent to upload all changes from the Subscriber before applying the updated snapshot files when processing the reinitialize request.

By default, the bUploadFirst parameter is set to FALSE.

Reinitializing a subscription by using the ReInitialize2 method requires appropriate permissions. The login used for the 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 subscribed-to publication.

Note  If an application calls ReInitialize2 on an instance of SQL Server version 7.0 and bUploadFirst is set to TRUE, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned. ReInitialize2 can be used with Microsoft® SQL Server™ 2000 and SQL Server 7.0 if bUploadFirst is set to FALSE .

See Also

ReInitialize Method