MergePublication.ValidateSubscription Method

Marks the specified subscription for validation during the next synchronization.

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

Syntax

'Declaration
Public Sub ValidateSubscription ( _
    subscriber As String, _
    subscriptionDB As String, _
    validationOption As ValidationOption _
)
'Usage
Dim instance As MergePublication 
Dim subscriber As String 
Dim subscriptionDB As String 
Dim validationOption As ValidationOption

instance.ValidateSubscription(subscriber, _
    subscriptionDB, validationOption)

public void ValidateSubscription(
    string subscriber,
    string subscriptionDB,
    ValidationOption validationOption
)

public:
void ValidateSubscription(
    String^ subscriber, 
    String^ subscriptionDB, 
    ValidationOption validationOption
)

member ValidateSubscription : 
        subscriber:string * 
        subscriptionDB:string * 
        validationOption:ValidationOption -> unit

public function ValidateSubscription(
    subscriber : String, 
    subscriptionDB : String, 
    validationOption : ValidationOption
)

Parameters

• subscriber
  Type: System.String
  The Subscriber.

• subscriptionDB
  Type: System.String
  The subscription database.

• validationOption
  Type: Microsoft.SqlServer.Replication.ValidationOption
  The validation options.

Remarks

The result of the validation operation is written to the agent history, which is viewed using Replication Monitor.

Calling ValidateSubscription is equivalent to executing sp_validatemergesubscription.

The ValidateSubscription method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

See Also

Reference

MergePublication Class

Microsoft.SqlServer.Replication Namespace

Other Resources

NIB Validate Data at the Subscriber (RMO Programming)

Validate Replicated Data