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

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. Quando você adiciona controle programático de replicação a um aplicativo ou realiza tarefas de replicação repetidas, como assinaturas de sincronização, será mais bem atendido se usar as interfaces de programação fornecidas pelo RMO (Replication Management Objects).

Manuais SQL Server online fornecem exemplos de como programar a maioria das tarefas de replicação comuns que usam procedimentos armazenados Transact-SQL. Para obter mais informações, consulte Conceitos dos procedimentos armazenados do sistema de replicação.

Importante
Somente procedimentos armazenados de replicação documentados nos Manuais SQL Server online têm suporte. Procedimentos armazenados não documentados são somente para uso de componentes de replicação internos e não devem ser usados para administrar replicação.

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)

Consulte também

Conceitos

Conceitos de Replication Management Objects

Conceitos de programação de replicação