sp_dropmergealternatepublisher (Transact-SQL)
Applies to:
SQL Server
Removes an alternate Publisher from a merge publication. This stored procedure is executed at the Subscriber on the subscription database.
Transact-SQL syntax conventions
Syntax
sp_dropmergealternatepublisher
[ @publisher = ] N'publisher'
, [ @publisher_db = ] N'publisher_db'
, [ @publication = ] N'publication'
, [ @alternate_publisher = ] N'alternate_publisher'
, [ @alternate_publisher_db = ] N'alternate_publisher_db'
, [ @alternate_publication = ] N'alternate_publication'
[ ; ]
Arguments
[ @publisher = ] N'publisher'
The name of the current Publisher. @publisher is sysname, with no default.
[ @publisher_db = ] N'publisher_db'
The name of the current publication database. @publisher_db is sysname, with no default.
[ @publication = ] N'publication'
The name of the current publication. @publication is sysname, with no default.
[ @alternate_publisher = ] N'alternate_publisher'
The name of the alternate Publisher to drop as the alternate synchronization partner. @alternate_publisher is sysname, with no default.
[ @alternate_publisher_db = ] N'alternate_publisher_db'
The name of the publication database to drop as the alternate synchronization partner publication database. @alternate_publisher_db is sysname, with no default.
[ @alternate_publication = ] N'alternate_publication'
The name of the publication to drop as the alternate synchronization partner publication. @alternate_publication is sysname, with no default.
Return code values
0
(success) or 1
(failure).
Remarks
sp_dropmergealternatepublisher
is used in merge replication.
Permissions
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergelternatepublisher
.
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για