Bagikan melalui


TransPublication.ReinitializeAllSubscriptions Method (Boolean)

Marks all subscriptions to the publication for reinitialization, with the option to invalidate an existing snapshot.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Sub ReinitializeAllSubscriptions ( _
    invalidateSnapshot As Boolean _
)
'Usage
Dim instance As TransPublication
Dim invalidateSnapshot As Boolean

instance.ReinitializeAllSubscriptions(invalidateSnapshot)
public void ReinitializeAllSubscriptions(
    bool invalidateSnapshot
)
public:
void ReinitializeAllSubscriptions(
    bool invalidateSnapshot
)
member ReinitializeAllSubscriptions : 
        invalidateSnapshot:bool -> unit 
public function ReinitializeAllSubscriptions(
    invalidateSnapshot : boolean
)

Parameters

  • invalidateSnapshot
    Type: System.Boolean
    Specifies whether an existing snapshot should be invalidated and re-created before subscriptions are reinitialized.

Remarks

The ReinitializeAllSubscriptions method can only be called by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by a user that created a subscription.

Calling ReinitializeAllSubscriptions is equivalent to executing sp_reinitsubscription.