Returns information about a subscription to a merge publication, both push and pull. This stored procedure is executed at the Publisher on the publication database or at a republishing Subscriber on the subscription database.
sp_helpmergesubscription [ [ @publication=] 'publication'] [ , [ @subscriber=] 'subscriber'] [ , [ @subscriber_db=] 'subscriber_db'] [ , [ @publisher=] 'publisher'] [ , [ @publisher_db=] 'publisher_db'] [ , [ @subscription_type=] 'subscription_type'] [ , [ @found=] 'found' OUTPUT]
Name of the subscription.
Name of the publication.
Name of the Publisher.
Name of the Publisher database.
Name of the Subscriber.
Name of the subscription database.
Status of the subscription:
0 = All jobs are waiting to start
1 = One or more jobs are starting
2 = All jobs have executed successfully
3 = At least one job is executing
4 = All jobs are scheduled and idle
5 = At least one job is attempting to execute after a previous failure
6 = At least one job has failed to execute successfully
Type of Subscriber.
Type of subscription:
0 = Push
1 = Pull
2 = Both
Number indicating the priority for the subscription.
Subscription sync type.
Brief description of this merge subscription.
Job ID of the Merge Agent.
Whether the subscription is to a full or filtered publication.
Specifies if offload execution of a replication agent has been set to run at the Subscriber. If NULL, execution is run at the Publisher.
Name of the server to where the agent is running.
Returns whether or not the interactive resolver is used during reconciliation. If 0, the interactive resolver not is used.
Value supplied when a subscription is filtered by the value of the HOST_NAME function.
Is the security mode at the Subscriber, where 1 means Windows Authentication, and 0 means Microsoft SQL Server Authentication.
Is the login name at the Subscriber.
Actual Subscriber password is never returned. The result is masked by a "******" string.
sp_helpmergesubscription is used in merge replication to return subscription information stored at the Publisher or republishing Subscriber.
For anonymous subscriptions, the subscription_typevalue is always 1 (pull). However, you must execute sp_helpmergepullsubscription at the Subscriber for information on anonymous subscriptions.