Procédures stockées de réplication (Transact-SQL)Replication Stored Procedures (Transact-SQL)

S’APPLIQUE À : ouiSQL Server ouiAzure SQL Database nonAzure Synapse Analytics (SQL DW) nonParallel Data Warehouse APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Les procédures stockées du système de réplication sont documentées et disponibles en tant que méthode pour accomplir des tâches qui s'exécutent une fois, comme la mise en œuvre de la réplication, et pour être utilisées dans des fichiers de commandes et des scripts.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.

La documentation en ligne de SQL ServerSQL Server fournit des exemples de procédures pour programmer la plupart des tâches de réplication avec les procédures stockées Transact-SQLTransact-SQL.SQL ServerSQL Server Books Online provides examples of how to program most of the common replication tasks using Transact-SQLTransact-SQL stored procedures. Pour plus d’informations, consultez Concepts liés aux procédures stockées système de réplication.For more information, see Replication System Stored Procedures Concepts.

Important

Seules les procédures stockées de réplication documentées dans la documentation en ligne de SQL ServerSQL Server sont prises en charge.Only the replication stored procedures documented in SQL ServerSQL Server Books Online are supported. Les procédures stockées non documentées sont uniquement destinées à l'utilisation de composants de réplication internes et ne doivent pas être utilisées pour administrer la réplication.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)sp_add_agent_parameter (Transact-SQL) sp_helparticledts (Transact-SQL)sp_helparticledts (Transact-SQL)
sp_add_agent_profile (Transact-SQL)sp_add_agent_profile (Transact-SQL) sp_helpdatatypemap (Transact-SQL)sp_helpdatatypemap (Transact-SQL)
sp_addarticle (Transact-SQL)sp_addarticle (Transact-SQL) sp_helpdistpublisher (Transact-SQL)sp_helpdistpublisher (Transact-SQL)
sp_adddistpublisher (Transact-SQL)sp_adddistpublisher (Transact-SQL) sp_helpdistributiondb (Transact-SQL)sp_helpdistributiondb (Transact-SQL)
sp_adddistributiondb (Transact-SQL)sp_adddistributiondb (Transact-SQL) sp_helpdistributor (Transact-SQL)sp_helpdistributor (Transact-SQL)
sp_adddistributor (Transact-SQL)sp_adddistributor (Transact-SQL) sp_helpdistributor_properties (Transact-SQL)sp_helpdistributor_properties (Transact-SQL)
sp_adddynamicsnapshot_job (Transact-SQL)sp_adddynamicsnapshot_job (Transact-SQL) sp_helpdynamicsnapshot_job (Transact-SQL)sp_helpdynamicsnapshot_job (Transact-SQL)
sp_addlogreader_agent (Transact-SQL)sp_addlogreader_agent (Transact-SQL) sp_helplogreader_agent (Transact-SQL)sp_helplogreader_agent (Transact-SQL)
sp_addmergealternatepublisher (Transact-SQL)sp_addmergealternatepublisher (Transact-SQL) sp_helpmergealternatepublisher (Transact-SQL)sp_helpmergealternatepublisher (Transact-SQL)
sp_addmergearticle (Transact-SQL)sp_addmergearticle (Transact-SQL) sp_helpmergearticle (Transact-SQL)sp_helpmergearticle (Transact-SQL)
sp_addmergefilter (Transact-SQL)sp_addmergefilter (Transact-SQL) sp_helpmergearticlecolumn (Transact-SQL)sp_helpmergearticlecolumn (Transact-SQL)
sp_addmergepartition (Transact-SQL)sp_addmergepartition (Transact-SQL) sp_helpmergearticleconflicts (Transact-SQL)sp_helpmergearticleconflicts (Transact-SQL)
sp_addmergepublication (Transact-SQL)sp_addmergepublication (Transact-SQL) sp_helpmergeconflictrows (Transact-SQL)sp_helpmergeconflictrows (Transact-SQL)
sp_addmergepullsubscription (Transact-SQL)sp_addmergepullsubscription (Transact-SQL) sp_helpmergedeleteconflictrows (Transact-SQL)sp_helpmergedeleteconflictrows (Transact-SQL)
sp_addmergepullsubscription_agent (Transact-SQL)sp_addmergepullsubscription_agent (Transact-SQL) sp_helpmergefilter (Transact-SQL)sp_helpmergefilter (Transact-SQL)
sp_addmergepushsubscription_agent (Transact-SQL)sp_addmergepushsubscription_agent (Transact-SQL) sp_helpmergepartition (Transact-SQL)sp_helpmergepartition (Transact-SQL)
sp_addmergesubscription (Transact-SQL)sp_addmergesubscription (Transact-SQL) sp_helpmergepublication (Transact-SQL)sp_helpmergepublication (Transact-SQL)
sp_addpublication (Transact-SQL)sp_addpublication (Transact-SQL) sp_helpmergepullsubscription (Transact-SQL)sp_helpmergepullsubscription (Transact-SQL)
sp_addpublication_snapshot (Transact-SQL)sp_addpublication_snapshot (Transact-SQL) sp_helpmergesubscription (Transact-SQL)sp_helpmergesubscription (Transact-SQL)
sp_addpullsubscription (Transact-SQL)sp_addpullsubscription (Transact-SQL) sp_help_peerconflictdetection (Transact-SQL)sp_help_peerconflictdetection (Transact-SQL)
sp_addpullsubscription_agent (Transact-SQL)sp_addpullsubscription_agent (Transact-SQL) sp_helppeerrequests (Transact-SQL)sp_helppeerrequests (Transact-SQL)
sp_addpushsubscription_agent (Transact-SQL)sp_addpushsubscription_agent (Transact-SQL) sp_helppeerresponses (Transact-SQL)sp_helppeerresponses (Transact-SQL)
sp_addqreader_agent (Transact-SQL)sp_addqreader_agent (Transact-SQL) sp_helppublication (Transact-SQL)sp_helppublication (Transact-SQL)
sp_addqueued_artinfo (Transact-SQL)sp_addqueued_artinfo (Transact-SQL) sp_helppublication_snapshot (Transact-SQL)sp_helppublication_snapshot (Transact-SQL)
sp_addscriptexec (Transact-SQL)sp_addscriptexec (Transact-SQL) sp_helppullsubscription (Transact-SQL)sp_helppullsubscription (Transact-SQL)
sp_addsubscriber (Transact-SQL)sp_addsubscriber (Transact-SQL) sp_helpqreader_agent (Transact-SQL)sp_helpqreader_agent (Transact-SQL)
sp_addsubscriber_schedule (Transact-SQL)sp_addsubscriber_schedule (Transact-SQL) sp_helpreplfailovermode (Transact-SQL)sp_helpreplfailovermode (Transact-SQL)
sp_addsubscription (Transact-SQL)sp_addsubscription (Transact-SQL) sp_helpreplicationdboption (Transact-SQL)sp_helpreplicationdboption (Transact-SQL)
sp_addsynctriggers (Transact-SQL)sp_addsynctriggers (Transact-SQL) sp_helpreplicationoption (Transact-SQL)sp_helpreplicationoption (Transact-SQL)
sp_addtabletocontents (Transact-SQL)sp_addtabletocontents (Transact-SQL) sp_helpsubscriberinfo (Transact-SQL)sp_helpsubscriberinfo (Transact-SQL)
sp_adjustpublisheridentityrange (Transact-SQL)sp_adjustpublisheridentityrange (Transact-SQL) sp_helpsubscription (Transact-SQL)sp_helpsubscription (Transact-SQL)
sp_article_validation (Transact-SQL)sp_article_validation (Transact-SQL) sp_helpsubscription_properties (Transact-SQL)sp_helpsubscription_properties (Transact-SQL)
sp_articlecolumn (Transact-SQL)sp_articlecolumn (Transact-SQL) sp_helpsubscriptionerrors (Transact-SQL)sp_helpsubscriptionerrors (Transact-SQL)
sp_articlefilter (Transact-SQL)sp_articlefilter (Transact-SQL) sp_helptracertokenhistory (Transact-SQL)sp_helptracertokenhistory (Transact-SQL)
Transact (-SQL de sp_articleview)sp_articleview (Transact-SQL) sp_helptracertokens (Transact-SQL)sp_helptracertokens (Transact-SQL)
sp_attachsubscription (Transact-SQL)sp_attachsubscription (Transact-SQL) sp_helpxactsetjob (Transact-SQL)sp_helpxactsetjob (Transact-SQL)
sp_browsemergesnapshotfolder (Transact-SQL)sp_browsemergesnapshotfolder (Transact-SQL) sp_ivindexhasnullcols (Transact-SQL)sp_ivindexhasnullcols (Transact-SQL)
sp_browsereplcmds (Transact-SQL)sp_browsereplcmds (Transact-SQL) sp_link_publication (Transact-SQL)sp_link_publication (Transact-SQL)
sp_browsesnapshotfolder (Transact-SQL)sp_browsesnapshotfolder (Transact-SQL) sp_lookupcustomresolver (Transact-SQL)sp_lookupcustomresolver (Transact-SQL)
sp_change_agent_parameter (Transact-SQL)sp_change_agent_parameter (Transact-SQL) sp_markpendingschemachange (Transact-SQL)sp_markpendingschemachange (Transact-SQL)
sp_change_agent_profile (Transact-SQL)sp_change_agent_profile (Transact-SQL) sp_marksubscriptionvalidation (Transact-SQL)sp_marksubscriptionvalidation (Transact-SQL)
sp_change_subscription_properties (Transact-SQL)sp_change_subscription_properties (Transact-SQL) sp_mergearticlecolumn (Transact-SQL)sp_mergearticlecolumn (Transact-SQL)
sp_changearticle (Transact-SQL)sp_changearticle (Transact-SQL) sp_mergecleanupmetadata (Transact-SQL)sp_mergecleanupmetadata (Transact-SQL)
sp_changearticlecolumndatatype (Transact-SQL)sp_changearticlecolumndatatype (Transact-SQL) sp_mergedummyupdate (Transact-SQL)sp_mergedummyupdate (Transact-SQL)
sp_changedistpublisher (Transact-SQL)sp_changedistpublisher (Transact-SQL) sp_mergemetadataretentioncleanup (Transact-SQL)sp_mergemetadataretentioncleanup (Transact-SQL)
sp_changedistributiondb (Transact-SQL)sp_changedistributiondb (Transact-SQL) sp_mergesubscription_cleanup (Transact-SQL)sp_mergesubscription_cleanup (Transact-SQL)
sp_changedistributor_password (Transact-SQL)sp_changedistributor_password (Transact-SQL) sp_MSchange_distribution_agent_properties (Transact-SQL)sp_MSchange_distribution_agent_properties (Transact-SQL)
sp_changedistributor_property (Transact-SQL)sp_changedistributor_property (Transact-SQL) sp_MSchange_logreader_agent_properties (Transact-SQL)sp_MSchange_logreader_agent_properties (Transact-SQL)
sp_changedynamicsnapshot_job (Transact-SQL)sp_changedynamicsnapshot_job (Transact-SQL) sp_MSchange_merge_agent_properties (Transact-SQL)sp_MSchange_merge_agent_properties (Transact-SQL)
sp_changelogreader_agent (Transact-SQL)sp_changelogreader_agent (Transact-SQL) sp_MSchange_snapshot_agent_properties (Transact-SQL)sp_MSchange_snapshot_agent_properties (Transact-SQL)
Transact (-SQL sp_changemergearticle)sp_changemergearticle (Transact-SQL) sp_posttracertoken (Transact-SQL)sp_posttracertoken (Transact-SQL)
sp_changemergefilter (Transact-SQL)sp_changemergefilter (Transact-SQL) sp_publication_validation (Transact-SQL)sp_publication_validation (Transact-SQL)
sp_changemergepublication (Transact-SQL)sp_changemergepublication (Transact-SQL) sp_publisherproperty (Transact-SQL)sp_publisherproperty (Transact-SQL)
sp_changemergepullsubscription (Transact-SQL)sp_changemergepullsubscription (Transact-SQL) sp_redirect_publisher (Transact-SQL)sp_redirect_publisher (Transact-SQL)
sp_changemergesubscription (Transact-SQL)sp_changemergesubscription (Transact-SQL) sp_refreshsubscriptions (Transact-SQL)sp_refreshsubscriptions (Transact-SQL)
sp_changepublication (Transact-SQL)sp_changepublication (Transact-SQL) sp_register_custom_scripting (Transact-SQL)sp_register_custom_scripting (Transact-SQL)
sp_changepublication_snapshot (Transact-SQL)sp_changepublication_snapshot (Transact-SQL) sp_registercustomresolver (Transact-SQL)sp_registercustomresolver (Transact-SQL)
sp_changeqreader_agent (Transact-SQL)sp_changeqreader_agent (Transact-SQL) sp_reinitmergepullsubscription (Transact-SQL)sp_reinitmergepullsubscription (Transact-SQL)
sp_changereplicationserverpasswords (Transact-SQL)sp_changereplicationserverpasswords (Transact-SQL) sp_reinitmergesubscription (Transact-SQL)sp_reinitmergesubscription (Transact-SQL)
sp_changesubscriber (Transact-SQL)sp_changesubscriber (Transact-SQL) sp_reinitpullsubscription (Transact-SQL)sp_reinitpullsubscription (Transact-SQL)
sp_changesubscriber_schedule (Transact-SQL)sp_changesubscriber_schedule (Transact-SQL) sp_reinitsubscription (Transact-SQL)sp_reinitsubscription (Transact-SQL)
sp_changesubscription (Transact-SQL)sp_changesubscription (Transact-SQL) sp_removedbreplication (Transact-SQL)sp_removedbreplication (Transact-SQL)
sp_changesubscriptiondtsinfo (Transact-SQL)sp_changesubscriptiondtsinfo (Transact-SQL) sp_removedistpublisherdbreplication (Transact-SQL)sp_removedistpublisherdbreplication (Transact-SQL)
sp_changesubstatus (Transact-SQL)sp_changesubstatus (Transact-SQL) sp_repladdcolumn (Transact-SQL)sp_repladdcolumn (Transact-SQL)
sp_check_dynamic_filters (Transact-SQL)sp_check_dynamic_filters (Transact-SQL) sp_replcmds (Transact-SQL)sp_replcmds (Transact-SQL)
sp_check_for_sync_trigger (Transact-SQL)sp_check_for_sync_trigger (Transact-SQL) sp_replcounters (Transact-SQL)sp_replcounters (Transact-SQL)
sp_check_join_filter (Transact-SQL)sp_check_join_filter (Transact-SQL) sp_repldone (Transact-SQL)sp_repldone (Transact-SQL)
sp_check_subset_filter (Transact-SQL)sp_check_subset_filter (Transact-SQL) sp_repldropcolumn (Transact-SQL)sp_repldropcolumn (Transact-SQL)
sp_configure_peerconflictdetection (Transact-SQL)sp_configure_peerconflictdetection (Transact-SQL) sp_replflush (Transact-SQL)sp_replflush (Transact-SQL)
sp_copymergesnapshot (Transact-SQL)sp_copymergesnapshot (Transact-SQL) sp_replication_agent_checkup (Transact-SQL)sp_replication_agent_checkup (Transact-SQL)
sp_copysnapshot (Transact-SQL)sp_copysnapshot (Transact-SQL) sp_replicationdboption (Transact-SQL)sp_replicationdboption (Transact-SQL)
sp_copysubscription (Transact-SQL)sp_copysubscription (Transact-SQL) sp_replmonitorchangepublicationthreshold (Transact-SQL)sp_replmonitorchangepublicationthreshold (Transact-SQL)
sp_deletemergeconflictrow (Transact-SQL)sp_deletemergeconflictrow (Transact-SQL) sp_replmonitorhelpmergesession (Transact-SQL)sp_replmonitorhelpmergesession (Transact-SQL)
sp_deletepeerrequesthistory (Transact-SQL)sp_deletepeerrequesthistory (Transact-SQL) sp_replmonitorhelpmergesessiondetail (Transact-SQL)sp_replmonitorhelpmergesessiondetail (Transact-SQL)
sp_deletetracertokenhistory (Transact-SQL)sp_deletetracertokenhistory (Transact-SQL) sp_replmonitorhelppublication (Transact-SQL)sp_replmonitorhelppublication (Transact-SQL)
sp_drop_agent_parameter (Transact-SQL)sp_drop_agent_parameter (Transact-SQL) sp_replmonitorhelppublicationthresholds (Transact-SQL)sp_replmonitorhelppublicationthresholds (Transact-SQL)
sp_drop_agent_profile (Transact-SQL)sp_drop_agent_profile (Transact-SQL) sp_replmonitorhelppublisher (Transact-SQL)sp_replmonitorhelppublisher (Transact-SQL)
sp_dropanonymousagent (Transact-SQL)sp_dropanonymousagent (Transact-SQL) sp_replmonitorhelpsubscription (Transact-SQL)sp_replmonitorhelpsubscription (Transact-SQL)
sp_droparticle (Transact-SQL)sp_droparticle (Transact-SQL) sp_replmonitorsubscriptionpendingcmds (Transact-SQL)sp_replmonitorsubscriptionpendingcmds (Transact-SQL)
sp_dropdistpublisher (Transact-SQL)sp_dropdistpublisher (Transact-SQL) sp_replqueuemonitor (Transact-SQL)sp_replqueuemonitor (Transact-SQL)
sp_dropdistributiondb (Transact-SQL)sp_dropdistributiondb (Transact-SQL) sp_replrestart (Transact-SQL)sp_replrestart (Transact-SQL)
sp_dropdistributor (Transact-SQL)sp_dropdistributor (Transact-SQL) sp_replsetoriginator (Transact-SQL)sp_replsetoriginator (Transact-SQL)
sp_dropdynamicsnapshot_job (Transact-SQL)sp_dropdynamicsnapshot_job (Transact-SQL) sp_replshowcmds (Transact-SQL)sp_replshowcmds (Transact-SQL)
sp_dropmergealternatepublisher (Transact-SQL)sp_dropmergealternatepublisher (Transact-SQL) sp_repltrans (Transact-SQL)sp_repltrans (Transact-SQL)
sp_dropmergearticle (Transact-SQL)sp_dropmergearticle (Transact-SQL) sp_requestpeerresponse (Transact-SQL)sp_requestpeerresponse (Transact-SQL)
sp_dropmergefilter (Transact-SQL)sp_dropmergefilter (Transact-SQL) sp_requestpeertopologyinfo (Transact-SQL)sp_requestpeertopologyinfo (Transact-SQL)
sp_dropmergepartition (Transact-SQL)sp_dropmergepartition (Transact-SQL) sp_resetsnapshotdeliveryprogress (Transact-SQL)sp_resetsnapshotdeliveryprogress (Transact-SQL)
sp_dropmergepublication (Transact-SQL)sp_dropmergepublication (Transact-SQL) sp_restoredbreplication (Transact-SQL)sp_restoredbreplication (Transact-SQL)
sp_dropmergepullsubscription (Transact-SQL)sp_dropmergepullsubscription (Transact-SQL) sp_restoremergeidentityrange (Transact-SQL)sp_restoremergeidentityrange (Transact-SQL)
sp_dropmergesubscription (Transact-SQL)sp_dropmergesubscription (Transact-SQL) sp_resyncmergesubscription (Transact-SQL)sp_resyncmergesubscription (Transact-SQL)
sp_droppublication (Transact-SQL)sp_droppublication (Transact-SQL) sp_revoke_publication_access (Transact-SQL)sp_revoke_publication_access (Transact-SQL)
- (SQL-Transact-SQL)sp_droppullsubscription (Transact-SQL) sp_schemafilter (Transact-SQL)sp_schemafilter (Transact-SQL)
sp_dropsubscriber (Transact-SQL)sp_dropsubscriber (Transact-SQL) sp_script_synctran_commands (Transact-SQL)sp_script_synctran_commands (Transact-SQL)
sp_dropsubscription (Transact-SQL)sp_dropsubscription (Transact-SQL) sp_scriptdynamicupdproc (Transact-SQL)sp_scriptdynamicupdproc (Transact-SQL)
sp_dsninfo (Transact-SQL)sp_dsninfo (Transact-SQL) sp_scriptpublicationcustomprocs (Transact-SQL)sp_scriptpublicationcustomprocs (Transact-SQL)
sp_enumcustomresolvers (Transact-SQL)sp_enumcustomresolvers (Transact-SQL) sp_scriptsubconflicttable (Transact-SQL)sp_scriptsubconflicttable (Transact-SQL)
sp_enumdsn (Transact-SQL)sp_enumdsn (Transact-SQL) sp_setdefaultdatatypemapping (Transact-SQL)sp_setdefaultdatatypemapping (Transact-SQL)
sp_enumeratependingschemachanges (Transact-SQL)sp_enumeratependingschemachanges (Transact-SQL) sp_setreplfailovermode (Transact-SQL)sp_setreplfailovermode (Transact-SQL)
sp_expired_subscription_cleanup (Transact-SQL)sp_expired_subscription_cleanup (Transact-SQL) sp_setsubscriptionxactseqno (Transact-SQL)sp_setsubscriptionxactseqno (Transact-SQL)
sp_generatefilters (Transact-SQL)sp_generatefilters (Transact-SQL) sp_showpendingchanges (Transact-SQL)sp_showpendingchanges (Transact-SQL)
sp_get_distributor (Transact-SQL)sp_get_distributor (Transact-SQL) sp_showrowreplicainfo (Transact-SQL)sp_showrowreplicainfo (Transact-SQL)
sp_get_redirected_publisher (Transact-SQL)sp_get_redirected_publisher (Transact-SQL) sp_startpublication_snapshot (Transact-SQL)sp_startpublication_snapshot (Transact-SQL)
sp_getagentparameterlist (Transact-SQL)sp_getagentparameterlist (Transact-SQL) sp_subscription_cleanup (Transact-SQL)sp_subscription_cleanup (Transact-SQL)
sp_getdefaultdatatypemapping (Transact-SQL)sp_getdefaultdatatypemapping (Transact-SQL) sp_table_validation (Transact-SQL)sp_table_validation (Transact-SQL)
sp_getmergedeletetype (Transact-SQL)sp_getmergedeletetype (Transact-SQL) sp_unregister_custom_scripting (Transact-SQL)sp_unregister_custom_scripting (Transact-SQL)
sp_getqueuedrows (Transact-SQL)sp_getqueuedrows (Transact-SQL) sp_unregistercustomresolver (Transact-SQL)sp_unregistercustomresolver (Transact-SQL)
sp_getsubscriptiondtspackagename (Transact-SQL)sp_getsubscriptiondtspackagename (Transact-SQL) sp_update_agent_profile (Transact-SQL)sp_update_agent_profile (Transact-SQL)
sp_gettopologyinfo (Transact-SQL)sp_gettopologyinfo (Transact-SQL) sp_validate_redirected_publisher (Transact-SQL)sp_validate_redirected_publisher (Transact-SQL)
(e-SQL de l’en-langage)sp_grant_publication_access (Transact-SQL) sp_validate_replica_hosts_as_publishers (Transact-SQL)sp_validate_replica_hosts_as_publishers (Transact-SQL)
sp_help_agent_default (Transact-SQL)sp_help_agent_default (Transact-SQL) sp_validatemergepublication (Transact-SQL)sp_validatemergepublication (Transact-SQL)
sp_help_agent_parameter (Transact-SQL)sp_help_agent_parameter (Transact-SQL) sp_validatemergesubscription (Transact-SQL)sp_validatemergesubscription (Transact-SQL)
sp_help_agent_profile (Transact-SQL)sp_help_agent_profile (Transact-SQL) sp_vupgrade_mergeobjects (Transact-SQL)sp_vupgrade_mergeobjects (Transact-SQL)
sp_helparticle (Transact-SQL)sp_helparticle (Transact-SQL) sp_vupgrade_replication (Transact-SQL)sp_vupgrade_replication (Transact-SQL)
sp_helparticlecolumns (Transact-SQL)sp_helparticlecolumns (Transact-SQL)

Voir aussiSee Also

Concepts liés à RMO (Replication Management Objects) Replication Management Objects Concepts
Concepts de programmation en matière de réplicationReplication Programming Concepts