Procedimientos almacenados de réplica (Transact-SQL)

  • Artículo

Los procedimientos almacenados del sistema de réplica se documentan y están disponibles como un método para realizar tareas únicas como la implementación de la réplica y el uso de archivos de proceso por lotes y secuencias de comandos. Si desea agregar un control de programación de la réplica para una aplicación o realizar tareas de réplica repetidas como la sincronización de suscripciones, se recomienda utilizar las interfaces de programación suministradas con los objetos de administración de réplica (RMO).

Los Libros en pantalla de SQL Server ofrecen ejemplos sobre cómo programar la mayoría de las tareas de réplica comunes mediante procedimientos almacenados de Transact-SQL. Para obtener más información, vea Programming Replication Using System Stored Procedures.

ms174364.note(es-es,SQL.90).gifImportante:
Sólo se admiten los procedimientos almacenados de réplica documentados en los Libros en pantalla de SQL Server. Los procedimientos almacenados no documentados sólo se utilizan para los componentes de réplica internos y no se pueden utilizar para administrar la réplica.

sp_add_agent_parameter (Transact-SQL)

sp_help_publication_access (Transact-SQL)

sp_add_agent_profile (Transact-SQL)

sp_helparticle (Transact-SQL)

sp_addarticle (Transact-SQL)

sp_helparticlecolumns (Transact-SQL)

sp_adddistpublisher (Transact-SQL)

sp_helparticledts (Transact-SQL)

sp_adddistributiondb (Transact-SQL)

sp_helpdatatypemap (Transact-SQL)

sp_adddistributor (Transact-SQL)

sp_helpdistpublisher (Transact-SQL)

sp_adddynamicsnapshot_job (Transact-SQL)

sp_helpdistributiondb (Transact-SQL)

sp_addlogreader_agent (Transact-SQL)

sp_helpdistributor (Transact-SQL)

sp_addmergealternatepublisher (Transact-SQL)

sp_helpdistributor_properties (Transact-SQL)

sp_addmergearticle (Transact-SQL)

sp_helpdynamicsnapshot_job (Transact-SQL)

sp_addmergefilter (Transact-SQL)

sp_helplogreader_agent (Transact-SQL)

sp_addmergepartition (Transact-SQL)

sp_helpmergealternatepublisher (Transact-SQL)

sp_addmergepublication (Transact-SQL)

sp_helpmergearticle (Transact-SQL)

sp_addmergepullsubscription (Transact-SQL)

sp_helpmergearticlecolumn (Transact-SQL)

sp_addmergepullsubscription_agent (Transact-SQL)

sp_helpmergearticleconflicts (Transact-SQL)

sp_addmergepushsubscription_agent (Transact-SQL)

sp_helpmergeconflictrows (Transact-SQL)

sp_addmergesubscription (Transact-SQL)

sp_helpmergedeleteconflictrows (Transact-SQL)

sp_addpublication (Transact-SQL)

sp_helpmergefilter (Transact-SQL)

sp_addpublication_snapshot (Transact-SQL)

sp_helpmergepartition (Transact-SQL)

sp_addpullsubscription (Transact-SQL)

sp_helpmergepublication (Transact-SQL)

sp_addpullsubscription_agent (Transact-SQL)

sp_helpmergepullsubscription (Transact-SQL)

sp_addpushsubscription_agent (Transact-SQL)

sp_helpmergesubscription (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_copymergesnapshot (Transact-SQL)

sp_repldropcolumn (Transact-SQL)

sp_copysnapshot (Transact-SQL)

sp_replflush (Transact-SQL)

sp_copysubscription (Transact-SQL)

sp_replication_agent_checkup (Transact-SQL)

sp_deletemergeconflictrow (Transact-SQL)

sp_replicationdboption (Transact-SQL)

sp_deletepeerrequesthistory (Transact-SQL)

sp_replmonitorchangepublicationthreshold (Transact-SQL)

sp_deletetracertokenhistory (Transact-SQL)

sp_replmonitorhelpmergesession (Transact-SQL)

sp_disableagentoffload (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_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_enableagentoffload (Transact-SQL)

sp_scriptsubconflicttable (Transact-SQL)

sp_enumcustomresolvers (Transact-SQL)

sp_setdefaultdatatypemapping (Transact-SQL)

sp_enumdsn (Transact-SQL)

sp_setreplfailovermode (Transact-SQL)

sp_enumeratependingschemachanges (Transact-SQL)

sp_setsubscriptionxactseqno (Transact-SQL)

sp_expired_subscription_cleanup (Transact-SQL)

sp_showpendingchanges (Transact-SQL)

sp_generatefilters (Transact-SQL)

sp_showrowreplicainfo (Transact-SQL)

sp_get_distributor (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_grant_publication_access (Transact-SQL)

sp_validatemergepublication (Transact-SQL)

sp_help_agent_default (Transact-SQL)

sp_validatemergesubscription (Transact-SQL)

sp_help_agent_parameter (Transact-SQL)

sp_vupgrade_mergeobjects (Transact-SQL)

sp_help_agent_profile (Transact-SQL)

sp_vupgrade_replication (Transact-SQL)

Vea también

Otros recursos

Programming with Replication Management Objects
Planning for Replication Programming

Ayuda e información

Obtener ayuda sobre SQL Server 2005