Procedimientos almacenados de replicación (Transact-SQL)

Artículo
05/08/2013

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.

Los Libros en pantalla 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
Solo se admiten los procedimientos almacenados de replicación documentados en los Libros en pantalla de SQL Server. 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.

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

Vea también

Conceptos

Conceptos de los Replication Management Objects (RMO)

Conceptos de la programación de replicación

Procedimientos almacenados de replicación (Transact-SQL)

Vea también

Conceptos

Recursos adicionales