MergePublication.ValidateSubscription Method

  • Article

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 _
)

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

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

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

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

Parameters

  • subscriber
    A String value that specifies the Subscriber.
  • subscriptionDB
    A String value that specifies the subscription database.
  • validationOption
    A ValidationOption value that specifies 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.

The ValidateSubscription method is available only for instances of Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

MergePublication Class
MergePublication Members
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Validate Data at the Subscriber (RMO Programming)
Validating Replicated Data