sp_helpmergealternatepublisher
Returns a list of all servers enabled as alternate Publishers for merge publications. This stored procedure is executed at the Subscriber on the subscription database.
Syntax
sp_helpmergealternatepublisher [ [ @publisher = ] 'publisher' ]
, [ @publisher_db = ] 'publisher_db'
, [ @publication = ] 'publication'
Arguments
[@publisher = ] 'publisher'
Is the name of the alternate publisher. publisher is sysname, with no default.
[@publisher_db = ] 'publisher_db'
Is the name of the publication database. publisher_db is sysname, with no default.
[@publication = ] 'publication'
Is the name of the publication. publication is sysname, with no default.
Result Sets
| Column name | Data type | Description |
|---|---|---|
| alternate publisher | sysname | Name of the alternate Publisher. |
| alternate publisher db | sysname | Name of the publication database. |
| alternate publication | sysname | Name of the publication. |
| alternate distributor | sysname | Name of the distributor. |
| friendly name | nvarchar(255) | Description of the alternate Publisher. |
| enabled | bit | Specifies if the server is an alternate Publisher. 1 specifies that the Publisher is enabled as an alternate Publisher. 0 specifies that it is not enabled. |
Remarks
sp_helpmergealternatepublisher is used in merge replication.
During every merge session, the system queries both the Publisher and Subscriber for each one's list of alternate publishers. The list of alternate publishers on both the Publisher and Subscriber has entries added or dropped as appropriate.
Permissions
Execute permissions default to the public role.