Procedimientos almacenados de replicación (Transact-SQL)Replication Stored Procedures (Transact-SQL)

ESTE TEMA SE APLICA A: síSQL Server (a partir de 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noAlmacenamiento de datos paralelos THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Los procedimientos almacenados del sistema de replicación están documentados y están disponibles como un método para realizar tareas únicas como la implementación de la replicación y el uso de archivos por lotes y 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.

Los Libros en pantalla de SQL ServerSQL Server ofrecen ejemplos sobre cómo programar la mayoría de las tareas de replicación comunes mediante procedimientos almacenados de 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 obtener más información, consulte Replication System Stored Procedures Concepts (Conceptos sobre los procedimientos almacenados del sistema de replicación).For more information, see Replication System Stored Procedures Concepts.

Importante

Solo se admiten los procedimientos almacenados de replicación documentados en los Libros en pantalla de SQL ServerSQL Server.Only the replication stored procedures documented in SQL ServerSQL Server Books Online are supported. Los procedimientos almacenados no documentados solo se utilizan para los componentes de replicación internos y no se pueden utilizar para administrar la replicación.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) el procedimiento 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)
sp_articleview (Transact-SQL)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)
sp_changemergearticle (Transact-SQL)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)
sp_droppullsubscription (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)
sp_grant_publication_access (Transact-SQL)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)

Vea tambiénSee Also

Replication Management Objects Concepts Replication Management Objects Concepts
Conceptos de la programación de replicaciónReplication Programming Concepts