MergePublication.MakePullSubscriptionWellKnown Method

Registers a merge pull subscription at the Publisher.

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

Syntax

'Declaration
Public Sub MakePullSubscriptionWellKnown ( _
    subscriber As String, _
    subscriptionDB As String, _
    syncType As SubscriptionSyncType, _
    subscriberType As MergeSubscriberType, _
    priority As Single _
)
'Usage
Dim instance As MergePublication 
Dim subscriber As String 
Dim subscriptionDB As String 
Dim syncType As SubscriptionSyncType 
Dim subscriberType As MergeSubscriberType 
Dim priority As Single

instance.MakePullSubscriptionWellKnown(subscriber, _
    subscriptionDB, syncType, subscriberType, _
    priority)
public void MakePullSubscriptionWellKnown(
    string subscriber,
    string subscriptionDB,
    SubscriptionSyncType syncType,
    MergeSubscriberType subscriberType,
    float priority
)
public:
void MakePullSubscriptionWellKnown(
    String^ subscriber, 
    String^ subscriptionDB, 
    SubscriptionSyncType syncType, 
    MergeSubscriberType subscriberType, 
    float priority
)
member MakePullSubscriptionWellKnown : 
        subscriber:string * 
        subscriptionDB:string * 
        syncType:SubscriptionSyncType * 
        subscriberType:MergeSubscriberType * 
        priority:float32 -> unit
public function MakePullSubscriptionWellKnown(
    subscriber : String, 
    subscriptionDB : String, 
    syncType : SubscriptionSyncType, 
    subscriberType : MergeSubscriberType, 
    priority : float
)

Parameters

  • subscriber
    Type: System.String
    The Subscriber where the pull subscription was created.
  • subscriptionDB
    Type: System.String
    The subscription database in which the pull subscription was created.
  • priority
    Type: System.Single
    The weighting of the pull subscription to resolve conflicts when more than one change occurs in the same replicated data.

Remarks

Use EnumSubscriptions to determine if a subscription is already registered at the Publisher. If the registration exists, MakePullSubscriptionWellKnown generates an error at the server.

The MakePullSubscriptionWellKnown 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.

Calling MakePullSubscriptionWellKnown is equivalent to executing sp_addmergesubscription to register the pull subscription.

See Also

Reference

MergePublication Class

Microsoft.SqlServer.Replication Namespace

Other Resources

NIB Create a Pull Subscription (RMO Programming)