--- title: "Replication Stored Procedures (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/17/2017" ms.prod: "sql-server-2016" ms.reviewer: "" ms.suite: "" ms.technology: - "replication" ms.tgt_pltfrm: "" ms.topic: "language-reference" applies_to: - "SQL Server" helpviewer_keywords: - "system stored procedures [SQL Server], replication" - "replication stored procedures [SQL Server]" - "stored procedures [SQL Server replication]" ms.assetid: 10996a2a-3be4-4f66-9fc4-815d43fc6e52 caps.latest.revision: 42 author: "BYHAM" ms.author: "rickbyh" manager: "jhubbard" --- # Replication Stored Procedures (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)] Replication system stored procedures are documented and available as a method for accomplishing one-time tasks, such as implementing replication, and for using in batch files and scripts. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online provides examples of how to program most of the common replication tasks using [!INCLUDE[tsql](../../includes/tsql-md.md)] stored procedures. For more information, see [Replication System Stored Procedures Concepts](../../relational-databases/replication/concepts/replication-system-stored-procedures-concepts.md). > [!IMPORTANT] > Only the replication stored procedures documented in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online are supported. Undocumented stored procedures are only for the use of internal replication components and should not be used to administer replication. ||| |-|-| |[sp_add_agent_parameter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-add-agent-parameter-transact-sql.md)|[sp_helparticledts (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helparticledts-transact-sql.md)| |[sp_add_agent_profile (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-add-agent-profile-transact-sql.md)|[sp_helpdatatypemap (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdatatypemap-transact-sql.md)| |[sp_addarticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addarticle-transact-sql.md)|[sp_helpdistpublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdistpublisher-transact-sql.md)| |[sp_adddistpublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-adddistpublisher-transact-sql.md)|[sp_helpdistributiondb (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdistributiondb-transact-sql.md)| |[sp_adddistributiondb (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-adddistributiondb-transact-sql.md)|[sp_helpdistributor (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdistributor-transact-sql.md)| |[sp_adddistributor (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-adddistributor-transact-sql.md)|[sp_helpdistributor_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdistributor-properties-transact-sql.md)| |[sp_adddynamicsnapshot_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-adddynamicsnapshot-job-transact-sql.md)|[sp_helpdynamicsnapshot_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpdynamicsnapshot-job-transact-sql.md)| |[sp_addlogreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addlogreader-agent-transact-sql.md)|[sp_helplogreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helplogreader-agent-transact-sql.md)| |[sp_addmergealternatepublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergealternatepublisher-transact-sql.md)|[sp_helpmergealternatepublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergealternatepublisher-transact-sql.md)| |[sp_addmergearticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergearticle-transact-sql.md)|[sp_helpmergearticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergearticle-transact-sql.md)| |[sp_addmergefilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergefilter-transact-sql.md)|[sp_helpmergearticlecolumn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergearticlecolumn-transact-sql.md)| |[sp_addmergepartition (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepartition-transact-sql.md)|[sp_helpmergearticleconflicts (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergearticleconflicts-transact-sql.md)| |[sp_addmergepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepublication-transact-sql.md)|[sp_helpmergeconflictrows (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergeconflictrows-transact-sql.md)| |[sp_addmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepullsubscription-transact-sql.md)|[sp_helpmergedeleteconflictrows (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergedeleteconflictrows-transact-sql.md)| |[sp_addmergepullsubscription_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepullsubscription-agent-transact-sql.md)|[sp_helpmergefilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergefilter-transact-sql.md)| |[sp_addmergepushsubscription_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergepushsubscription-agent-transact-sql.md)|[sp_helpmergepartition (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergepartition-transact-sql.md)| |[sp_addmergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addmergesubscription-transact-sql.md)|[sp_helpmergepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergepublication-transact-sql.md)| |[sp_addpublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addpublication-transact-sql.md)|[sp_helpmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergepullsubscription-transact-sql.md)| |[sp_addpublication_snapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addpublication-snapshot-transact-sql.md)|[sp_helpmergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpmergesubscription-transact-sql.md)| |[sp_addpullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addpullsubscription-transact-sql.md)|[sp_help_peerconflictdetection (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-help-peerconflictdetection-transact-sql.md)| |[sp_addpullsubscription_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addpullsubscription-agent-transact-sql.md)|[sp_helppeerrequests (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppeerrequests-transact-sql.md)| |[sp_addpushsubscription_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addpushsubscription-agent-transact-sql.md)|[sp_helppeerresponses (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppeerresponses-transact-sql.md)| |[sp_addqreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addqreader-agent-transact-sql.md)|[sp_helppublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppublication-transact-sql.md)| |[sp_addqueued_artinfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addqueued-artinfo-transact-sql.md)|[sp_helppublication_snapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppublication-snapshot-transact-sql.md)| |[sp_addscriptexec (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addscriptexec-transact-sql.md)|[sp_helppullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppullsubscription-transact-sql.md)| |[sp_addsubscriber (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addsubscriber-transact-sql.md)|[sp_helpqreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpqreader-agent-transact-sql.md)| |[sp_addsubscriber_schedule (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addsubscriber-schedule-transact-sql.md)|[sp_helpreplfailovermode (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpreplfailovermode-transact-sql.md)| |[sp_addsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addsubscription-transact-sql.md)|[sp_helpreplicationdboption (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpreplicationdboption-transact-sql.md)| |[sp_addsynctriggers (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addsynctriggers-transact-sql.md)|[sp_helpreplicationoption (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpreplicationoption-transact-sql.md)| |[sp_addtabletocontents (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-addtabletocontents-transact-sql.md)|[sp_helpsubscriberinfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscriberinfo-transact-sql.md)| |[sp_adjustpublisheridentityrange (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-adjustpublisheridentityrange-transact-sql.md)|[sp_helpsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscription-transact-sql.md)| |[sp_article_validation (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-article-validation-transact-sql.md)|[sp_helpsubscription_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscription-properties-transact-sql.md)| |[sp_articlecolumn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-articlecolumn-transact-sql.md)|[sp_helpsubscriptionerrors (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscriptionerrors-transact-sql.md)| |[sp_articlefilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-articlefilter-transact-sql.md)|[sp_helptracertokenhistory (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helptracertokenhistory-transact-sql.md)| |[sp_articleview (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-articleview-transact-sql.md)|[sp_helptracertokens (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helptracertokens-transact-sql.md)| |[sp_attachsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-attachsubscription-transact-sql.md)|[sp_helpxactsetjob (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpxactsetjob-transact-sql.md)| |[sp_browsemergesnapshotfolder (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-browsemergesnapshotfolder-transact-sql.md)|[sp_ivindexhasnullcols (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-ivindexhasnullcols-transact-sql.md)| |[sp_browsereplcmds (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-browsereplcmds-transact-sql.md)|[sp_link_publication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-link-publication-transact-sql.md)| |[sp_browsesnapshotfolder (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-browsesnapshotfolder-transact-sql.md)|[sp_lookupcustomresolver (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-lookupcustomresolver-transact-sql.md)| |[sp_change_agent_parameter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-change-agent-parameter-transact-sql.md)|[sp_markpendingschemachange (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-markpendingschemachange-transact-sql.md)| |[sp_change_agent_profile (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-change-agent-profile-transact-sql.md)|[sp_marksubscriptionvalidation (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-marksubscriptionvalidation-transact-sql.md)| |[sp_change_subscription_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-change-subscription-properties-transact-sql.md)|[sp_mergearticlecolumn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mergearticlecolumn-transact-sql.md)| |[sp_changearticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changearticle-transact-sql.md)|[sp_mergecleanupmetadata (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mergecleanupmetadata-transact-sql.md)| |[sp_changearticlecolumndatatype (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changearticlecolumndatatype-transact-sql.md)|[sp_mergedummyupdate (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mergedummyupdate-transact-sql.md)| |[sp_changedistpublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changedistpublisher-transact-sql.md)|[sp_mergemetadataretentioncleanup (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mergemetadataretentioncleanup-transact-sql.md)| |[sp_changedistributiondb (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changedistributiondb-transact-sql.md)|[sp_mergesubscription_cleanup (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mergesubscription-cleanup-transact-sql.md)| |[sp_changedistributor_password (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changedistributor-password-transact-sql.md)|[sp_MSchange_distribution_agent_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mschange-distribution-agent-properties-transact-sql.md)| |[sp_changedistributor_property (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changedistributor-property-transact-sql.md)|[sp_MSchange_logreader_agent_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mschange-logreader-agent-properties-transact-sql.md)| |[sp_changedynamicsnapshot_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changedynamicsnapshot-job-transact-sql.md)|[sp_MSchange_merge_agent_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mschange-merge-agent-properties-transact-sql.md)| |[sp_changelogreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changelogreader-agent-transact-sql.md)|[sp_MSchange_snapshot_agent_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-mschange-snapshot-agent-properties-transact-sql.md)| |[sp_changemergearticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changemergearticle-transact-sql.md)|[sp_posttracertoken (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-posttracertoken-transact-sql.md)| |[sp_changemergefilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changemergefilter-transact-sql.md)|[sp_publication_validation (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-publication-validation-transact-sql.md)| |[sp_changemergepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changemergepublication-transact-sql.md)|[sp_publisherproperty (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-publisherproperty-transact-sql.md)| |[sp_changemergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changemergepullsubscription-transact-sql.md)|[sp_redirect_publisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-redirect-publisher-transact-sql.md)| |[sp_changemergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changemergesubscription-transact-sql.md)|[sp_refreshsubscriptions (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-refreshsubscriptions-transact-sql.md)| |[sp_changepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changepublication-transact-sql.md)|[sp_register_custom_scripting (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-register-custom-scripting-transact-sql.md)| |[sp_changepublication_snapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changepublication-snapshot-transact-sql.md)|[sp_registercustomresolver (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-registercustomresolver-transact-sql.md)| |[sp_changeqreader_agent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changeqreader-agent-transact-sql.md)|[sp_reinitmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-reinitmergepullsubscription-transact-sql.md)| |[sp_changereplicationserverpasswords (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changereplicationserverpasswords-transact-sql.md)|[sp_reinitmergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-reinitmergesubscription-transact-sql.md)| |[sp_changesubscriber (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changesubscriber-transact-sql.md)|[sp_reinitpullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-reinitpullsubscription-transact-sql.md)| |[sp_changesubscriber_schedule (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changesubscriber-schedule-transact-sql.md)|[sp_reinitsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-reinitsubscription-transact-sql.md)| |[sp_changesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changesubscription-transact-sql.md)|[sp_removedbreplication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-removedbreplication-transact-sql.md)| |[sp_changesubscriptiondtsinfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changesubscriptiondtsinfo-transact-sql.md)|[sp_removedistpublisherdbreplication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-removedistpublisherdbreplication-transact-sql.md)| |[sp_changesubstatus (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-changesubstatus-transact-sql.md)|[sp_repladdcolumn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-repladdcolumn-transact-sql.md)| |[sp_check_dynamic_filters (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-check-dynamic-filters-transact-sql.md)|[sp_replcmds (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replcmds-transact-sql.md)| |[sp_check_for_sync_trigger (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-check-for-sync-trigger-transact-sql.md)|[sp_replcounters (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replcounters-transact-sql.md)| |[sp_check_join_filter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-check-join-filter-transact-sql.md)|[sp_repldone (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-repldone-transact-sql.md)| |[sp_check_subset_filter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-check-subset-filter-transact-sql.md)|[sp_repldropcolumn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-repldropcolumn-transact-sql.md)| |[sp_configure_peerconflictdetection (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-configure-peerconflictdetection-transact-sql.md)|[sp_replflush (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replflush-transact-sql.md)| |[sp_copymergesnapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-copymergesnapshot-transact-sql.md)|[sp_replication_agent_checkup (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replication-agent-checkup-transact-sql.md)| |[sp_copysnapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-copysnapshot-transact-sql.md)|[sp_replicationdboption (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replicationdboption-transact-sql.md)| |[sp_copysubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-copysubscription-transact-sql.md)|[sp_replmonitorchangepublicationthreshold (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorchangepublicationthreshold-transact-sql.md)| |[sp_deletemergeconflictrow (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-deletemergeconflictrow-transact-sql.md)|[sp_replmonitorhelpmergesession (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelpmergesession-transact-sql.md)| |[sp_deletepeerrequesthistory (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-deletepeerrequesthistory-transact-sql.md)|[sp_replmonitorhelpmergesessiondetail (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelpmergesessiondetail-transact-sql.md)| |[sp_deletetracertokenhistory (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-deletetracertokenhistory-transact-sql.md)|[sp_replmonitorhelppublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelppublication-transact-sql.md)| |[sp_drop_agent_parameter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-drop-agent-parameter-transact-sql.md)|[sp_replmonitorhelppublicationthresholds (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelppublicationthresholds-transact-sql.md)| |[sp_drop_agent_profile (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-drop-agent-profile-transact-sql.md)|[sp_replmonitorhelppublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelppublisher-transact-sql.md)| |[sp_dropanonymousagent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropanonymousagent-transact-sql.md)|[sp_replmonitorhelpsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorhelpsubscription-transact-sql.md)| |[sp_droparticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-droparticle-transact-sql.md)|[sp_replmonitorsubscriptionpendingcmds (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replmonitorsubscriptionpendingcmds-transact-sql.md)| |[sp_dropdistpublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropdistpublisher-transact-sql.md)|[sp_replqueuemonitor (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replqueuemonitor-transact-sql.md)| |[sp_dropdistributiondb (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropdistributiondb-transact-sql.md)|[sp_replrestart (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replrestart-transact-sql.md)| |[sp_dropdistributor (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropdistributor-transact-sql.md)|[sp_replsetoriginator (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replsetoriginator-transact-sql.md)| |[sp_dropdynamicsnapshot_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropdynamicsnapshot-job-transact-sql.md)|[sp_replshowcmds (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-replshowcmds-transact-sql.md)| |[sp_dropmergealternatepublisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergealternatepublisher-transact-sql.md)|[sp_repltrans (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-repltrans-transact-sql.md)| |[sp_dropmergearticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergearticle-transact-sql.md)|[sp_requestpeerresponse (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-requestpeerresponse-transact-sql.md)| |[sp_dropmergefilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergefilter-transact-sql.md)|[sp_requestpeertopologyinfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-requestpeertopologyinfo-transact-sql.md)| |[sp_dropmergepartition (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergepartition-transact-sql.md)|[sp_resetsnapshotdeliveryprogress (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-resetsnapshotdeliveryprogress-transact-sql.md)| |[sp_dropmergepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergepublication-transact-sql.md)|[sp_restoredbreplication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-restoredbreplication-transact-sql.md)| |[sp_dropmergepullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergepullsubscription-transact-sql.md)|[sp_restoremergeidentityrange (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-restoremergeidentityrange-transact-sql.md)| |[sp_dropmergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropmergesubscription-transact-sql.md)|[sp_resyncmergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-resyncmergesubscription-transact-sql.md)| |[sp_droppublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-droppublication-transact-sql.md)|[sp_revoke_publication_access (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-revoke-publication-access-transact-sql.md)| |[sp_droppullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-droppullsubscription-transact-sql.md)|[sp_schemafilter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-schemafilter-transact-sql.md)| |[sp_dropsubscriber (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropsubscriber-transact-sql.md)|[sp_script_synctran_commands (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-script-synctran-commands-transact-sql.md)| |[sp_dropsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropsubscription-transact-sql.md)|[sp_scriptdynamicupdproc (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-scriptdynamicupdproc-transact-sql.md)| |[sp_dsninfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dsninfo-transact-sql.md)|[sp_scriptpublicationcustomprocs (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-scriptpublicationcustomprocs-transact-sql.md)| |[sp_enumcustomresolvers (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-enumcustomresolvers-transact-sql.md)|[sp_scriptsubconflicttable (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-scriptsubconflicttable-transact-sql.md)| |[sp_enumdsn (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-enumdsn-transact-sql.md)|[sp_setdefaultdatatypemapping (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-setdefaultdatatypemapping-transact-sql.md)| |[sp_enumeratependingschemachanges (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-enumeratependingschemachanges-transact-sql.md)|[sp_setreplfailovermode (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-setreplfailovermode-transact-sql.md)| |[sp_expired_subscription_cleanup (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-expired-subscription-cleanup-transact-sql.md)|[sp_setsubscriptionxactseqno (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-setsubscriptionxactseqno-transact-sql.md)| |[sp_generatefilters (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-generatefilters-transact-sql.md)|[sp_showpendingchanges (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-showpendingchanges-transact-sql.md)| |[sp_get_distributor (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-get-distributor-transact-sql.md)|[sp_showrowreplicainfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-showrowreplicainfo-transact-sql.md)| |[sp_get_redirected_publisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-get-redirected-publisher-transact-sql.md)|[sp_startpublication_snapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-startpublication-snapshot-transact-sql.md)| |[sp_getagentparameterlist (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-getagentparameterlist-transact-sql.md)|[sp_subscription_cleanup (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-subscription-cleanup-transact-sql.md)| |[sp_getdefaultdatatypemapping (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-getdefaultdatatypemapping-transact-sql.md)|[sp_table_validation (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-table-validation-transact-sql.md)| |[sp_getmergedeletetype (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-getmergedeletetype-transact-sql.md)|[sp_unregister_custom_scripting (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-unregister-custom-scripting-transact-sql.md)| |[sp_getqueuedrows (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-getqueuedrows-transact-sql.md)|[sp_unregistercustomresolver (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-unregistercustomresolver-transact-sql.md)| |[sp_getsubscriptiondtspackagename (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-getsubscriptiondtspackagename-transact-sql.md)|[sp_update_agent_profile (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-update-agent-profile-transact-sql.md)| |[sp_gettopologyinfo (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-gettopologyinfo-transact-sql.md)|[sp_validate_redirected_publisher (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-validate-redirected-publisher-transact-sql.md)| |[sp_grant_publication_access (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-grant-publication-access-transact-sql.md)|[sp_validate_replica_hosts_as_publishers (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-validate-replica-hosts-as-publishers-transact-sql.md)| |[sp_help_agent_default (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-help-agent-default-transact-sql.md)|[sp_validatemergepublication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-validatemergepublication-transact-sql.md)| |[sp_help_agent_parameter (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-help-agent-parameter-transact-sql.md)|[sp_validatemergesubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-validatemergesubscription-transact-sql.md)| |[sp_help_agent_profile (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-help-agent-profile-transact-sql.md)|[sp_vupgrade_mergeobjects (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-vupgrade-mergeobjects-transact-sql.md)| |[sp_helparticle (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helparticle-transact-sql.md)|[sp_vupgrade_replication (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-vupgrade-replication-transact-sql.md)| |[sp_helparticlecolumns (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helparticlecolumns-transact-sql.md)|| ## See Also [Replication Management Objects Concepts](../../relational-databases/replication/concepts/replication-management-objects-concepts.md) [Replication Programming Concepts](../../relational-databases/replication/concepts/replication-programming-concepts.md)