Procedimentos armazenados de replicação (Transact-SQL)Replication Stored Procedures (Transact-SQL)

APLICA-SE A: simSQL Server simBanco de Dados SQL do Azure nãoAzure Synapse Analytics (SQL DW) nãoParallel Data Warehouse APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Os procedimentos armazenados do sistema de replicação são documentados e disponibilizados como um método de execução única de tarefas, como implementação de replicação, e para uso em arquivos de lote e 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.

Os Manuais Online do SQL ServerSQL Server fornecem exemplos de como programar a maioria das tarefas de replicação comuns usando procedimentos armazenados 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. Para obter mais informações, consulte Conceitos de procedimentos armazenados no sistema de replicação.For more information, see Replication System Stored Procedures Concepts.

Importante

Apenas procedimentos armazenados de replicação documentados nos Manuais Online do SQL ServerSQL Server têm suporte.Only the replication stored procedures documented in SQL ServerSQL Server Books Online are supported. Procedimentos armazenados não documentados são para uso apenas de componentes de replicação internos e não devem ser usados para administrar replicação.Undocumented stored procedures are only for the use of internal replication components and should not be used to administer replication.

Transact (-SQL sp_add_agent_parameter)sp_add_agent_parameter (Transact-SQL) Transact (-SQL sp_helparticledts)sp_helparticledts (Transact-SQL)
Transact (-SQL sp_add_agent_profile)sp_add_agent_profile (Transact-SQL) sp_helpdatatypemap (Transact-SQL)sp_helpdatatypemap (Transact-SQL)
sp_addarticle (Transact-SQL)sp_addarticle (Transact-SQL) Transact (-SQL sp_helpdistpublisher)sp_helpdistpublisher (Transact-SQL)
sp_adddistpublisher (Transact-SQL)sp_adddistpublisher (Transact-SQL) Transact (-SQL sp_helpdistributiondb)sp_helpdistributiondb (Transact-SQL)
sp_adddistributiondb (Transact-SQL)sp_adddistributiondb (Transact-SQL) Transact (-SQL sp_helpdistributor)sp_helpdistributor (Transact-SQL)
sp_adddistributor (Transact-SQL)sp_adddistributor (Transact-SQL) Transact (-SQL sp_helpdistributor_properties)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) Transact (-SQL sp_helplogreader_agent)sp_helplogreader_agent (Transact-SQL)
sp_addmergealternatepublisher (Transact-SQL)sp_addmergealternatepublisher (Transact-SQL) Transact (-SQL sp_helpmergealternatepublisher)sp_helpmergealternatepublisher (Transact-SQL)
Transact (-SQL sp_addmergearticle)sp_addmergearticle (Transact-SQL) Transact (-SQL sp_helpmergearticle)sp_helpmergearticle (Transact-SQL)
Transact (-SQL sp_addmergefilter)sp_addmergefilter (Transact-SQL) Transact (-SQL sp_helpmergearticlecolumn)sp_helpmergearticlecolumn (Transact-SQL)
Transact (-SQL sp_addmergepartition)sp_addmergepartition (Transact-SQL) Transact (-SQL sp_helpmergearticleconflicts)sp_helpmergearticleconflicts (Transact-SQL)
Transact (-SQL sp_addmergepublication)sp_addmergepublication (Transact-SQL) Transact (-SQL sp_helpmergeconflictrows)sp_helpmergeconflictrows (Transact-SQL)
Transact (-SQL sp_addmergepullsubscription)sp_addmergepullsubscription (Transact-SQL) Transact (-SQL sp_helpmergedeleteconflictrows)sp_helpmergedeleteconflictrows (Transact-SQL)
sp_addmergepullsubscription_agent (Transact-SQL)sp_addmergepullsubscription_agent (Transact-SQL) Transact (-SQL sp_helpmergefilter)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)
Transact (-SQL sp_addpullsubscription)sp_addpullsubscription (Transact-SQL) Transact (-SQL sp_help_peerconflictdetection)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)
Transact (-SQL sp_addqueued_artinfo)sp_addqueued_artinfo (Transact-SQL) Transact (-SQL sp_helppublication_snapshot)sp_helppublication_snapshot (Transact-SQL)
Transact (-SQL sp_addscriptexec)sp_addscriptexec (Transact-SQL) Transact (-SQL sp_helppullsubscription)sp_helppullsubscription (Transact-SQL)
sp_addsubscriber (Transact-SQL)sp_addsubscriber (Transact-SQL) sp_helpqreader_agent (Transact-SQL)sp_helpqreader_agent (Transact-SQL)
Transact (-SQL sp_addsubscriber_schedule)sp_addsubscriber_schedule (Transact-SQL) Transact (-SQL sp_helpreplfailovermode)sp_helpreplfailovermode (Transact-SQL)
sp_addsubscription (Transact-SQL)sp_addsubscription (Transact-SQL) Transact (-SQL sp_helpreplicationdboption)sp_helpreplicationdboption (Transact-SQL)
Transact (-SQL sp_addsynctriggers)sp_addsynctriggers (Transact-SQL) Transact (-SQL sp_helpreplicationoption)sp_helpreplicationoption (Transact-SQL)
Transact (-SQL sp_addtabletocontents)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)
Transact (-SQL sp_article_validation)sp_article_validation (Transact-SQL) sp_helpsubscription_properties (Transact-SQL)sp_helpsubscription_properties (Transact-SQL)
Transact (-SQL sp_articlecolumn)sp_articlecolumn (Transact-SQL) Transact (-SQL sp_helpsubscriptionerrors)sp_helpsubscriptionerrors (Transact-SQL)
Transact (-SQL sp_articlefilter)sp_articlefilter (Transact-SQL) sp_helptracertokenhistory (Transact-SQL)sp_helptracertokenhistory (Transact-SQL)
Transact (-SQL sp_articleview)sp_articleview (Transact-SQL) Transact (-SQL sp_helptracertokens)sp_helptracertokens (Transact-SQL)
Transact (-SQL sp_attachsubscription)sp_attachsubscription (Transact-SQL) Transact (-SQL sp_helpxactsetjob)sp_helpxactsetjob (Transact-SQL)
Transact (-SQL sp_browsemergesnapshotfolder)sp_browsemergesnapshotfolder (Transact-SQL) Transact (-SQL sp_ivindexhasnullcols)sp_ivindexhasnullcols (Transact-SQL)
Transact (-SQL sp_browsereplcmds)sp_browsereplcmds (Transact-SQL) sp_link_publication (Transact-SQL)sp_link_publication (Transact-SQL)
Transact (-SQL sp_browsesnapshotfolder)sp_browsesnapshotfolder (Transact-SQL) Transact (-SQL sp_lookupcustomresolver)sp_lookupcustomresolver (Transact-SQL)
Transact (-SQL sp_change_agent_parameter)sp_change_agent_parameter (Transact-SQL) Transact (-SQL sp_markpendingschemachange)sp_markpendingschemachange (Transact-SQL)
Transact (-SQL sp_change_agent_profile)sp_change_agent_profile (Transact-SQL) Transact (-SQL sp_marksubscriptionvalidation)sp_marksubscriptionvalidation (Transact-SQL)
Transact (-SQL sp_change_subscription_properties)sp_change_subscription_properties (Transact-SQL) sp_mergearticlecolumn (Transact-SQL)sp_mergearticlecolumn (Transact-SQL)
sp_changearticle (Transact-SQL)sp_changearticle (Transact-SQL) Transact (-SQL sp_mergecleanupmetadata)sp_mergecleanupmetadata (Transact-SQL)
Transact (-SQL sp_changearticlecolumndatatype)sp_changearticlecolumndatatype (Transact-SQL) Transact (-SQL sp_mergedummyupdate)sp_mergedummyupdate (Transact-SQL)
sp_changedistpublisher (Transact-SQL)sp_changedistpublisher (Transact-SQL) Transact (-SQL sp_mergemetadataretentioncleanup)sp_mergemetadataretentioncleanup (Transact-SQL)
Transact (-SQL sp_changedistributiondb)sp_changedistributiondb (Transact-SQL) Transact (-SQL sp_mergesubscription_cleanup)sp_mergesubscription_cleanup (Transact-SQL)
Transact (-SQL sp_changedistributor_password)sp_changedistributor_password (Transact-SQL) Transact (-SQL sp_MSchange_distribution_agent_properties)sp_MSchange_distribution_agent_properties (Transact-SQL)
Transact (-SQL sp_changedistributor_property)sp_changedistributor_property (Transact-SQL) Transact (-SQL sp_MSchange_logreader_agent_properties)sp_MSchange_logreader_agent_properties (Transact-SQL)
Transact (-SQL sp_changedynamicsnapshot_job)sp_changedynamicsnapshot_job (Transact-SQL) Transact (-SQL sp_MSchange_merge_agent_properties)sp_MSchange_merge_agent_properties (Transact-SQL)
sp_changelogreader_agent (Transact-SQL)sp_changelogreader_agent (Transact-SQL) Transact (-SQL sp_MSchange_snapshot_agent_properties)sp_MSchange_snapshot_agent_properties (Transact-SQL)
Transact (-SQL de sp_changemergearticle)sp_changemergearticle (Transact-SQL) Transact (-SQL sp_posttracertoken)sp_posttracertoken (Transact-SQL)
Transact (-SQL sp_changemergefilter)sp_changemergefilter (Transact-SQL) Transact (-SQL sp_publication_validation)sp_publication_validation (Transact-SQL)
Transact (-SQL sp_changemergepublication)sp_changemergepublication (Transact-SQL) sp_publisherproperty (Transact-SQL)sp_publisherproperty (Transact-SQL)
Transact (-SQL sp_changemergepullsubscription)sp_changemergepullsubscription (Transact-SQL) Transact (-SQL sp_redirect_publisher)sp_redirect_publisher (Transact-SQL)
Transact (-SQL sp_changemergesubscription)sp_changemergesubscription (Transact-SQL) Transact (-SQL sp_refreshsubscriptions)sp_refreshsubscriptions (Transact-SQL)
Transact (-SQL sp_changepublication)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) Transact (-SQL sp_registercustomresolver)sp_registercustomresolver (Transact-SQL)
Transact (-SQL sp_changeqreader_agent)sp_changeqreader_agent (Transact-SQL) Transact (-SQL sp_reinitmergepullsubscription)sp_reinitmergepullsubscription (Transact-SQL)
Transact (-SQL sp_changereplicationserverpasswords)sp_changereplicationserverpasswords (Transact-SQL) Transact (-SQL sp_reinitmergesubscription)sp_reinitmergesubscription (Transact-SQL)
sp_changesubscriber (Transact-SQL)sp_changesubscriber (Transact-SQL) Transact (-SQL sp_reinitpullsubscription)sp_reinitpullsubscription (Transact-SQL)
Transact (-SQL sp_changesubscriber_schedule)sp_changesubscriber_schedule (Transact-SQL) Transact (-SQL sp_reinitsubscription)sp_reinitsubscription (Transact-SQL)
Transact (-SQL sp_changesubscription)sp_changesubscription (Transact-SQL) Transact (-SQL sp_removedbreplication)sp_removedbreplication (Transact-SQL)
Transact (-SQL sp_changesubscriptiondtsinfo)sp_changesubscriptiondtsinfo (Transact-SQL) Transact (-SQL sp_removedistpublisherdbreplication)sp_removedistpublisherdbreplication (Transact-SQL)
Transact (-SQL sp_changesubstatus)sp_changesubstatus (Transact-SQL) Transact (-SQL sp_repladdcolumn)sp_repladdcolumn (Transact-SQL)
Transact (-SQL sp_check_dynamic_filters)sp_check_dynamic_filters (Transact-SQL) Transact (-SQL sp_replcmds)sp_replcmds (Transact-SQL)
Transact (-SQL sp_check_for_sync_trigger)sp_check_for_sync_trigger (Transact-SQL) Transact (-SQL sp_replcounters)sp_replcounters (Transact-SQL)
Transact (-SQL sp_check_join_filter)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) Transact (-SQL sp_repldropcolumn)sp_repldropcolumn (Transact-SQL)
Transact (-SQL sp_configure_peerconflictdetection)sp_configure_peerconflictdetection (Transact-SQL) Transact (-SQL sp_replflush)sp_replflush (Transact-SQL)
Transact (-SQL sp_copymergesnapshot)sp_copymergesnapshot (Transact-SQL) Transact (-SQL sp_replication_agent_checkup)sp_replication_agent_checkup (Transact-SQL)
Transact (-SQL sp_copysnapshot)sp_copysnapshot (Transact-SQL) sp_replicationdboption (Transact-SQL)sp_replicationdboption (Transact-SQL)
Transact (-SQL sp_copysubscription)sp_copysubscription (Transact-SQL) Transact (-SQL sp_replmonitorchangepublicationthreshold)sp_replmonitorchangepublicationthreshold (Transact-SQL)
Transact (-SQL sp_deletemergeconflictrow)sp_deletemergeconflictrow (Transact-SQL) Transact (-SQL sp_replmonitorhelpmergesession)sp_replmonitorhelpmergesession (Transact-SQL)
Transact (-SQL sp_deletepeerrequesthistory)sp_deletepeerrequesthistory (Transact-SQL) Transact (-SQL sp_replmonitorhelpmergesessiondetail)sp_replmonitorhelpmergesessiondetail (Transact-SQL)
sp_deletetracertokenhistory (Transact-SQL)sp_deletetracertokenhistory (Transact-SQL) Transact (-SQL sp_replmonitorhelppublication)sp_replmonitorhelppublication (Transact-SQL)
Transact (-SQL sp_drop_agent_parameter)sp_drop_agent_parameter (Transact-SQL) Transact (-SQL sp_replmonitorhelppublicationthresholds)sp_replmonitorhelppublicationthresholds (Transact-SQL)
Transact (-SQL sp_drop_agent_profile)sp_drop_agent_profile (Transact-SQL) Transact (-SQL sp_replmonitorhelppublisher)sp_replmonitorhelppublisher (Transact-SQL)
Transact (-SQL sp_dropanonymousagent)sp_dropanonymousagent (Transact-SQL) Transact (-SQL sp_replmonitorhelpsubscription)sp_replmonitorhelpsubscription (Transact-SQL)
Transact (-SQL sp_droparticle)sp_droparticle (Transact-SQL) Transact (-SQL sp_replmonitorsubscriptionpendingcmds)sp_replmonitorsubscriptionpendingcmds (Transact-SQL)
sp_dropdistpublisher (Transact-SQL)sp_dropdistpublisher (Transact-SQL) Transact (-SQL sp_replqueuemonitor)sp_replqueuemonitor (Transact-SQL)
Transact (-SQL sp_dropdistributiondb)sp_dropdistributiondb (Transact-SQL) Transact (-SQL sp_replrestart)sp_replrestart (Transact-SQL)
Transact (-SQL sp_dropdistributor)sp_dropdistributor (Transact-SQL) Transact (-SQL sp_replsetoriginator)sp_replsetoriginator (Transact-SQL)
Transact (-SQL sp_dropdynamicsnapshot_job)sp_dropdynamicsnapshot_job (Transact-SQL) Transact (-SQL sp_replshowcmds)sp_replshowcmds (Transact-SQL)
Transact (-SQL sp_dropmergealternatepublisher)sp_dropmergealternatepublisher (Transact-SQL) Transact (-SQL sp_repltrans)sp_repltrans (Transact-SQL)
Transact (-SQL sp_dropmergearticle)sp_dropmergearticle (Transact-SQL) sp_requestpeerresponse (Transact-SQL)sp_requestpeerresponse (Transact-SQL)
Transact (-SQL sp_dropmergefilter)sp_dropmergefilter (Transact-SQL) Transact (-SQL sp_requestpeertopologyinfo)sp_requestpeertopologyinfo (Transact-SQL)
sp_dropmergepartition (Transact-SQL)sp_dropmergepartition (Transact-SQL) Transact (-SQL sp_resetsnapshotdeliveryprogress)sp_resetsnapshotdeliveryprogress (Transact-SQL)
Transact (-SQL sp_dropmergepublication)sp_dropmergepublication (Transact-SQL) Transact (-SQL sp_restoredbreplication)sp_restoredbreplication (Transact-SQL)
Transact (-SQL sp_dropmergepullsubscription)sp_dropmergepullsubscription (Transact-SQL) Transact (-SQL sp_restoremergeidentityrange)sp_restoremergeidentityrange (Transact-SQL)
Transact (-SQL sp_dropmergesubscription)sp_dropmergesubscription (Transact-SQL) Transact (-SQL sp_resyncmergesubscription)sp_resyncmergesubscription (Transact-SQL)
sp_droppublication (Transact-SQL)sp_droppublication (Transact-SQL) Transact (-SQL sp_revoke_publication_access)sp_revoke_publication_access (Transact-SQL)
Transact (-SQL sp_droppullsubscription)sp_droppullsubscription (Transact-SQL) Transact (-SQL sp_schemafilter)sp_schemafilter (Transact-SQL)
Transact (-SQL sp_dropsubscriber)sp_dropsubscriber (Transact-SQL) Transact (-SQL sp_script_synctran_commands)sp_script_synctran_commands (Transact-SQL)
sp_dropsubscription (Transact-SQL)sp_dropsubscription (Transact-SQL) Transact (-SQL sp_scriptdynamicupdproc)sp_scriptdynamicupdproc (Transact-SQL)
sp_dsninfo (Transact-SQL)sp_dsninfo (Transact-SQL) Transact (-SQL sp_scriptpublicationcustomprocs)sp_scriptpublicationcustomprocs (Transact-SQL)
sp_enumcustomresolvers (Transact-SQL)sp_enumcustomresolvers (Transact-SQL) Transact (-SQL sp_scriptsubconflicttable)sp_scriptsubconflicttable (Transact-SQL)
Transact (-SQL sp_enumdsn)sp_enumdsn (Transact-SQL) sp_setdefaultdatatypemapping (Transact-SQL)sp_setdefaultdatatypemapping (Transact-SQL)
Transact (-SQL sp_enumeratependingschemachanges)sp_enumeratependingschemachanges (Transact-SQL) sp_setreplfailovermode (Transact-SQL)sp_setreplfailovermode (Transact-SQL)
Transact (-SQL sp_expired_subscription_cleanup)sp_expired_subscription_cleanup (Transact-SQL) Transact (-SQL sp_setsubscriptionxactseqno)sp_setsubscriptionxactseqno (Transact-SQL)
Transact (-SQL sp_generatefilters)sp_generatefilters (Transact-SQL) Transact (-SQL sp_showpendingchanges)sp_showpendingchanges (Transact-SQL)
Transact (-SQL sp_get_distributor)sp_get_distributor (Transact-SQL) Transact (-SQL sp_showrowreplicainfo)sp_showrowreplicainfo (Transact-SQL)
Transact (-SQL sp_get_redirected_publisher)sp_get_redirected_publisher (Transact-SQL) Transact (-SQL sp_startpublication_snapshot)sp_startpublication_snapshot (Transact-SQL)
Transact (-SQL sp_getagentparameterlist)sp_getagentparameterlist (Transact-SQL) Transact (-SQL sp_subscription_cleanup)sp_subscription_cleanup (Transact-SQL)
Transact (-SQL sp_getdefaultdatatypemapping)sp_getdefaultdatatypemapping (Transact-SQL) Transact (-SQL sp_table_validation)sp_table_validation (Transact-SQL)
Transact (-SQL sp_getmergedeletetype)sp_getmergedeletetype (Transact-SQL) sp_unregister_custom_scripting (Transact-SQL)sp_unregister_custom_scripting (Transact-SQL)
Transact (-SQL sp_getqueuedrows)sp_getqueuedrows (Transact-SQL) Transact (-SQL sp_unregistercustomresolver)sp_unregistercustomresolver (Transact-SQL)
Transact (-SQL sp_getsubscriptiondtspackagename)sp_getsubscriptiondtspackagename (Transact-SQL) Transact (-SQL sp_update_agent_profile)sp_update_agent_profile (Transact-SQL)
Transact (-SQL sp_gettopologyinfo)sp_gettopologyinfo (Transact-SQL) sp_validate_redirected_publisher (Transact-SQL)sp_validate_redirected_publisher (Transact-SQL)
Transact (-SQL sp_grant_publication_access)sp_grant_publication_access (Transact-SQL) sp_validate_replica_hosts_as_publishers (Transact-SQL)sp_validate_replica_hosts_as_publishers (Transact-SQL)
Transact (-SQL sp_help_agent_default)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) Transact (-SQL sp_vupgrade_mergeobjects)sp_vupgrade_mergeobjects (Transact-SQL)
sp_helparticle (Transact-SQL)sp_helparticle (Transact-SQL) Transact (-SQL sp_vupgrade_replication)sp_vupgrade_replication (Transact-SQL)
sp_helparticlecolumns (Transact-SQL)sp_helparticlecolumns (Transact-SQL)

Consulte tambémSee Also

Replication Management Objects Concepts Replication Management Objects Concepts
Conceitos de programação da replicaçãoReplication Programming Concepts