Хранимые процедуры репликации (Transact-SQL)Replication Stored Procedures (Transact-SQL)

ОБЛАСТЬ ПРИМЕНЕНИЯ: даSQL Server (начиная с версии 2012) нетБаза данных SQL Azure нетХранилище данных SQL AzureнетParallel Data Warehouse APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Системные хранимые процедуры репликации документированы и доступны для выполнения единовременных задач, таких как реализация репликации и применение пакетных файлов и скриптов.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.

В электронной документации по SQL ServerSQL Server приводятся примеры программирования большинства общих задач репликации с помощью хранимых процедур 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. Дополнительные сведения см. в статье Основные понятия системных хранимых процедур репликации.For more information, see Replication System Stored Procedures Concepts.

Важно!

Поддерживаются только хранимые процедуры репликации, описанные в электронной документации по SQL ServerSQL Server.Only the replication stored procedures documented in SQL ServerSQL Server Books Online are supported. Недокументированные хранимые процедуры используются только для внутренних компонентов репликации и не должны применяться для управления репликацией.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) хранимую процедуру (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) 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)

См. такжеSee Also

Replication Management Objects Concepts Replication Management Objects Concepts
Основные понятия программирования репликацииReplication Programming Concepts