Procedimientos almacenados de replicación (Transact-SQL)

Los procedimientos almacenados del sistema de replicación se documentan 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. Si desea agregar un control de programación de la replicación para una aplicación o realizar tareas de replicación repetidas como la sincronización de suscripciones, se recomienda utilizar las interfaces de programación suministradas con los objetos de administración de replicación (RMO).

Los Libros en línea de SQL Server ofrecen ejemplos sobre cómo programar la mayoría de las tareas de replicación comunes mediante procedimientos almacenados de Transact-SQL. Para obtener más información, vea Conceptos sobre los procedimientos almacenados del sistema de replicación.

Importante
Sólo se admiten los procedimientos almacenados de replicación documentados en los Libros en línea de SQL Server.Los procedimientos almacenados no documentados sólo se utilizan para los componentes de replicación internos y no se pueden utilizar para administrar la replicación.

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

Vea también

Conceptos

Conceptos de los Objetos de administración de replicación (RMO)

Conceptos de la programación de replicación