복제 저장 프로시저(Transact-SQL)Replication Stored Procedures (Transact-SQL)

적용 대상:Applies to: 예SQL ServerSQL Server(지원되는 모든 버전)yesSQL ServerSQL Server (all supported versions) 예Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database적용 대상:Applies to: 예SQL ServerSQL Server(지원되는 모든 버전)yesSQL ServerSQL Server (all supported versions) 예Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database

복제 시스템 저장 프로시저는 복제 구현과 같은 일회적인 태스크나 배치 파일이나 스크립트에서 사용할 수 있도록 문서화되고 사용됩니다.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 저장 프로시저를 사용하여 대부분의 일반적인 복제 태스크를 프로그래밍하는 방법에 대한 예를 제공합니다.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.

Transact-sql)sp_add_agent_parameter (sp_add_agent_parameter (Transact-SQL)
Transact-sql)sp_add_agent_profile (sp_add_agent_profile (Transact-SQL)
sp_addarticle(Transact-SQL)sp_addarticle (Transact-SQL)
sp_adddistpublisher(Transact-SQL)sp_adddistpublisher (Transact-SQL)
sp_adddistributiondb(Transact-SQL)sp_adddistributiondb (Transact-SQL)
sp_adddistributor(Transact-SQL)sp_adddistributor (Transact-SQL)
Transact-sql)sp_adddynamicsnapshot_job (sp_adddynamicsnapshot_job (Transact-SQL)
sp_addlogreader_agent(Transact-SQL)sp_addlogreader_agent (Transact-SQL)
Transact-sql)sp_addmergealternatepublisher (sp_addmergealternatepublisher (Transact-SQL)
Transact-sql)sp_addmergearticle (sp_addmergearticle (Transact-SQL)
sp_addmergefilter(Transact-SQL)sp_addmergefilter (Transact-SQL)
Transact-sql)sp_addmergepartition (sp_addmergepartition (Transact-SQL)
Transact-sql)sp_addmergepublication (sp_addmergepublication (Transact-SQL)
Transact-sql)sp_addmergepullsubscription (sp_addmergepullsubscription (Transact-SQL)
sp_addmergepullsubscription_agent(Transact-SQL)sp_addmergepullsubscription_agent (Transact-SQL)
sp_addmergepushsubscription_agent(Transact-SQL)sp_addmergepushsubscription_agent (Transact-SQL)
Transact-sql)sp_addmergesubscription (sp_addmergesubscription (Transact-SQL)
sp_addpublication(Transact-SQL)sp_addpublication (Transact-SQL)
sp_addpublication_snapshot(Transact-SQL)sp_addpublication_snapshot (Transact-SQL)
Transact-sql)sp_addpullsubscription (sp_addpullsubscription (Transact-SQL)
sp_addpullsubscription_agent(Transact-SQL)sp_addpullsubscription_agent (Transact-SQL)
sp_addpushsubscription_agent(Transact-SQL)sp_addpushsubscription_agent (Transact-SQL)
sp_addqreader_agent(Transact-SQL)sp_addqreader_agent (Transact-SQL)
Transact-sql)sp_addqueued_artinfo (sp_addqueued_artinfo (Transact-SQL)
Transact-sql)sp_addscriptexec (sp_addscriptexec (Transact-SQL)
sp_addsubscriber(Transact-SQL)sp_addsubscriber (Transact-SQL)
Transact-sql)sp_addsubscriber_schedule (sp_addsubscriber_schedule (Transact-SQL)
Transact-sql)sp_addsubscription (sp_addsubscription (Transact-SQL)
Transact-sql)sp_addsynctriggers (sp_addsynctriggers (Transact-SQL)
Transact-sql)sp_addtabletocontents (sp_addtabletocontents (Transact-SQL)
sp_adjustpublisheridentityrange(Transact-SQL)sp_adjustpublisheridentityrange (Transact-SQL)
Transact-sql)sp_article_validation (sp_article_validation (Transact-SQL)
sp_articlecolumn(Transact-SQL)sp_articlecolumn (Transact-SQL)
sp_articlefilter(Transact-SQL)sp_articlefilter (Transact-SQL)
Transact-sql)sp_articleview (sp_articleview (Transact-SQL)
Transact-sql)sp_attachsubscription (sp_attachsubscription (Transact-SQL)
Transact-sql)sp_browsemergesnapshotfolder (sp_browsemergesnapshotfolder (Transact-SQL)
Transact-sql)sp_browsereplcmds (sp_browsereplcmds (Transact-SQL)
Transact-sql)sp_browsesnapshotfolder (sp_browsesnapshotfolder (Transact-SQL)
Transact-sql)sp_change_agent_parameter (sp_change_agent_parameter (Transact-SQL)
Transact-sql)sp_change_agent_profile (sp_change_agent_profile (Transact-SQL)
Transact-sql)sp_change_subscription_properties (sp_change_subscription_properties (Transact-SQL)
sp_changearticle(Transact-SQL)sp_changearticle (Transact-SQL)
sp_changearticlecolumndatatype(Transact-SQL)sp_changearticlecolumndatatype (Transact-SQL)
sp_changedistpublisher(Transact-SQL)sp_changedistpublisher (Transact-SQL)
Transact-sql)sp_changedistributiondb (sp_changedistributiondb (Transact-SQL)
Transact-sql)sp_changedistributor_password (sp_changedistributor_password (Transact-SQL)
Transact-sql)sp_changedistributor_property (sp_changedistributor_property (Transact-SQL)
Transact-sql)sp_changedynamicsnapshot_job (sp_changedynamicsnapshot_job (Transact-SQL)
Transact-sql)sp_changelogreader_agent (sp_changelogreader_agent (Transact-SQL)
sp_changemergearticle(Transact-SQL)sp_changemergearticle (Transact-SQL)
sp_changemergefilter(Transact-SQL)sp_changemergefilter (Transact-SQL)
sp_changemergepublication(Transact-SQL)sp_changemergepublication (Transact-SQL)
Transact-sql)sp_changemergepullsubscription (sp_changemergepullsubscription (Transact-SQL)
Transact-sql)sp_changemergesubscription (sp_changemergesubscription (Transact-SQL)
sp_changepublication(Transact-SQL)sp_changepublication (Transact-SQL)
Transact-sql)sp_changepublication_snapshot (sp_changepublication_snapshot (Transact-SQL)
Transact-sql)sp_changeqreader_agent (sp_changeqreader_agent (Transact-SQL)
Transact-sql)sp_changereplicationserverpasswords (sp_changereplicationserverpasswords (Transact-SQL)
sp_changesubscriber(Transact-SQL)sp_changesubscriber (Transact-SQL)
Transact-sql)sp_changesubscriber_schedule (sp_changesubscriber_schedule (Transact-SQL)
Transact-sql)sp_changesubscription (sp_changesubscription (Transact-SQL)
Transact-sql)sp_changesubscriptiondtsinfo (sp_changesubscriptiondtsinfo (Transact-SQL)
Transact-sql)sp_changesubstatus (sp_changesubstatus (Transact-SQL)
Transact-sql)sp_check_dynamic_filters (sp_check_dynamic_filters (Transact-SQL)
Transact-sql)sp_check_for_sync_trigger (sp_check_for_sync_trigger (Transact-SQL)
Transact-sql)sp_check_join_filter (sp_check_join_filter (Transact-SQL)
Transact-sql)sp_check_subset_filter (sp_check_subset_filter (Transact-SQL)
Transact-sql)sp_configure_peerconflictdetection (sp_configure_peerconflictdetection (Transact-SQL)
Transact-sql)sp_copymergesnapshot (sp_copymergesnapshot (Transact-SQL)
Transact-sql)sp_copysnapshot (sp_copysnapshot (Transact-SQL)
Transact-sql)sp_copysubscription (sp_copysubscription (Transact-SQL)
Transact-sql)sp_deletemergeconflictrow (sp_deletemergeconflictrow (Transact-SQL)
Transact-sql)sp_deletepeerrequesthistory (sp_deletepeerrequesthistory (Transact-SQL)
Transact-sql)sp_deletetracertokenhistory (sp_deletetracertokenhistory (Transact-SQL)
Transact-sql)sp_drop_agent_parameter (sp_drop_agent_parameter (Transact-SQL)
Transact-sql)sp_drop_agent_profile (sp_drop_agent_profile (Transact-SQL)
Transact-sql)sp_dropanonymousagent (sp_dropanonymousagent (Transact-SQL)
sp_droparticle(Transact-SQL)sp_droparticle (Transact-SQL)
Transact-sql)sp_dropdistpublisher (sp_dropdistpublisher (Transact-SQL)
Transact-sql)sp_dropdistributiondb (sp_dropdistributiondb (Transact-SQL)
Transact-sql)sp_dropdistributor (sp_dropdistributor (Transact-SQL)
Transact-sql)sp_dropdynamicsnapshot_job (sp_dropdynamicsnapshot_job (Transact-SQL)
Transact-sql)sp_dropmergealternatepublisher (sp_dropmergealternatepublisher (Transact-SQL)
sp_dropmergearticle(Transact-SQL)sp_dropmergearticle (Transact-SQL)
sp_dropmergefilter(Transact-SQL)sp_dropmergefilter (Transact-SQL)
Transact-sql)sp_dropmergepartition (sp_dropmergepartition (Transact-SQL)
Transact-sql)sp_dropmergepublication (sp_dropmergepublication (Transact-SQL)
Transact-sql)sp_dropmergepullsubscription (sp_dropmergepullsubscription (Transact-SQL)
Transact-sql)sp_dropmergesubscription (sp_dropmergesubscription (Transact-SQL)
Transact-sql)sp_droppublication (sp_droppublication (Transact-SQL)
Transact-sql)sp_droppullsubscription (sp_droppullsubscription (Transact-SQL)
Transact-sql)sp_dropsubscriber (sp_dropsubscriber (Transact-SQL)
Transact-sql)sp_dropsubscription (sp_dropsubscription (Transact-SQL)
sp_dsninfo(Transact-SQL)sp_dsninfo (Transact-SQL)
sp_enumcustomresolvers(Transact-SQL)sp_enumcustomresolvers (Transact-SQL)
Transact-sql)sp_enumdsn (sp_enumdsn (Transact-SQL)
Transact-sql)sp_enumeratependingschemachanges (sp_enumeratependingschemachanges (Transact-SQL)
Transact-sql)sp_expired_subscription_cleanup (sp_expired_subscription_cleanup (Transact-SQL)
Transact-sql)sp_generatefilters (sp_generatefilters (Transact-SQL)
sp_get_distributor(Transact-SQL)sp_get_distributor (Transact-SQL)
Transact-sql)sp_get_redirected_publisher (sp_get_redirected_publisher (Transact-SQL)
Transact-sql)sp_getagentparameterlist (sp_getagentparameterlist (Transact-SQL)
Transact-sql)sp_getdefaultdatatypemapping (sp_getdefaultdatatypemapping (Transact-SQL)
Transact-sql)sp_getmergedeletetype (sp_getmergedeletetype (Transact-SQL)
Transact-sql)sp_getqueuedrows (sp_getqueuedrows (Transact-SQL)
Transact-sql)sp_getsubscriptiondtspackagename (sp_getsubscriptiondtspackagename (Transact-SQL)
Transact-sql)sp_gettopologyinfo (sp_gettopologyinfo (Transact-SQL)
Transact-sql)sp_grant_publication_access (sp_grant_publication_access (Transact-SQL)
Transact-sql)sp_help_agent_default (sp_help_agent_default (Transact-SQL)
Transact-sql)sp_help_agent_parameter (sp_help_agent_parameter (Transact-SQL)
Transact-sql)sp_help_agent_profile (sp_help_agent_profile (Transact-SQL)
sp_helparticle(Transact-SQL)sp_helparticle (Transact-SQL)
Transact-sql)sp_helparticlecolumns (sp_helparticlecolumns (Transact-SQL)

Transact-sql)sp_helparticledts (sp_helparticledts (Transact-SQL)
Transact-sql)sp_helpdatatypemap (sp_helpdatatypemap (Transact-SQL)
sp_helpdistpublisher(Transact-SQL)sp_helpdistpublisher (Transact-SQL)
sp_helpdistributiondb(Transact-SQL)sp_helpdistributiondb (Transact-SQL)
sp_helpdistributor(Transact-SQL)sp_helpdistributor (Transact-SQL)
Transact-sql)sp_helpdistributor_properties (sp_helpdistributor_properties (Transact-SQL)
Transact-sql)sp_helpdynamicsnapshot_job (sp_helpdynamicsnapshot_job (Transact-SQL)
Transact-sql)sp_helplogreader_agent (sp_helplogreader_agent (Transact-SQL)
Transact-sql)sp_helpmergealternatepublisher (sp_helpmergealternatepublisher (Transact-SQL)
sp_helpmergearticle(Transact-SQL)sp_helpmergearticle (Transact-SQL)
Transact-sql)sp_helpmergearticlecolumn (sp_helpmergearticlecolumn (Transact-SQL)
Transact-sql)sp_helpmergearticleconflicts (sp_helpmergearticleconflicts (Transact-SQL)
Transact-sql)sp_helpmergeconflictrows (sp_helpmergeconflictrows (Transact-SQL)
Transact-sql)sp_helpmergedeleteconflictrows (sp_helpmergedeleteconflictrows (Transact-SQL)
Transact-sql)sp_helpmergefilter (sp_helpmergefilter (Transact-SQL)
Transact-sql)sp_helpmergepartition (sp_helpmergepartition (Transact-SQL)
sp_helpmergepublication(Transact-SQL)sp_helpmergepublication (Transact-SQL)
Transact-sql)sp_helpmergepullsubscription (sp_helpmergepullsubscription (Transact-SQL)
Transact-sql)sp_helpmergesubscription (sp_helpmergesubscription (Transact-SQL)
Transact-sql)sp_help_peerconflictdetection (sp_help_peerconflictdetection (Transact-SQL)
Transact-sql)sp_helppeerrequests (sp_helppeerrequests (Transact-SQL)
Transact-sql)sp_helppeerresponses (sp_helppeerresponses (Transact-SQL)
sp_helppublication(Transact-SQL)sp_helppublication (Transact-SQL)
Transact-sql)sp_helppublication_snapshot (sp_helppublication_snapshot (Transact-SQL)
Transact-sql)sp_helppullsubscription (sp_helppullsubscription (Transact-SQL)
Transact-sql)sp_helpqreader_agent (sp_helpqreader_agent (Transact-SQL)
Transact-sql)sp_helpreplfailovermode (sp_helpreplfailovermode (Transact-SQL)
sp_helpreplicationdboption(Transact-SQL)sp_helpreplicationdboption (Transact-SQL)
Transact-sql)sp_helpreplicationoption (sp_helpreplicationoption (Transact-SQL)
sp_helpsubscriberinfo(Transact-SQL)sp_helpsubscriberinfo (Transact-SQL)
Transact-sql)sp_helpsubscription (sp_helpsubscription (Transact-SQL)
sp_helpsubscription_properties(Transact-SQL)sp_helpsubscription_properties (Transact-SQL)
Transact-sql)sp_helpsubscriptionerrors (sp_helpsubscriptionerrors (Transact-SQL)
Transact-sql)sp_helptracertokenhistory (sp_helptracertokenhistory (Transact-SQL)
Transact-sql)sp_helptracertokens (sp_helptracertokens (Transact-SQL)
Transact-sql)sp_helpxactsetjob (sp_helpxactsetjob (Transact-SQL)
Transact-sql)sp_ivindexhasnullcols (sp_ivindexhasnullcols (Transact-SQL)
sp_link_publication(Transact-SQL)sp_link_publication (Transact-SQL)
Transact-sql)sp_lookupcustomresolver (sp_lookupcustomresolver (Transact-SQL)
Transact-sql)sp_markpendingschemachange (sp_markpendingschemachange (Transact-SQL)
Transact-sql)sp_marksubscriptionvalidation (sp_marksubscriptionvalidation (Transact-SQL)
sp_mergearticlecolumn(Transact-SQL)sp_mergearticlecolumn (Transact-SQL)
Transact-sql)sp_mergecleanupmetadata (sp_mergecleanupmetadata (Transact-SQL)
Transact-sql)sp_mergedummyupdate (sp_mergedummyupdate (Transact-SQL)
Transact-sql)sp_mergemetadataretentioncleanup (sp_mergemetadataretentioncleanup (Transact-SQL)
Transact-sql)sp_mergesubscription_cleanup (sp_mergesubscription_cleanup (Transact-SQL)
Transact-sql)sp_MSchange_distribution_agent_properties (sp_MSchange_distribution_agent_properties (Transact-SQL)
Transact-sql)sp_MSchange_logreader_agent_properties (sp_MSchange_logreader_agent_properties (Transact-SQL)
Transact-sql)sp_MSchange_merge_agent_properties (sp_MSchange_merge_agent_properties (Transact-SQL)
Transact-sql)sp_MSchange_snapshot_agent_properties (sp_MSchange_snapshot_agent_properties (Transact-SQL)
Transact-sql)sp_posttracertoken (sp_posttracertoken (Transact-SQL)
Transact-sql)sp_publication_validation (sp_publication_validation (Transact-SQL)
Transact-sql)sp_publisherproperty (sp_publisherproperty (Transact-SQL)
Transact-sql)sp_redirect_publisher (sp_redirect_publisher (Transact-SQL)
Transact-sql)sp_refreshsubscriptions (sp_refreshsubscriptions (Transact-SQL)
Transact-sql)sp_register_custom_scripting (sp_register_custom_scripting (Transact-SQL)
Transact-sql)sp_registercustomresolver (sp_registercustomresolver (Transact-SQL)
Transact-sql)sp_reinitmergepullsubscription (sp_reinitmergepullsubscription (Transact-SQL)
Transact-sql)sp_reinitmergesubscription (sp_reinitmergesubscription (Transact-SQL)
Transact-sql)sp_reinitpullsubscription (sp_reinitpullsubscription (Transact-SQL)
Transact-sql)sp_reinitsubscription (sp_reinitsubscription (Transact-SQL)
sp_removedbreplication(Transact-SQL)sp_removedbreplication (Transact-SQL)
Transact-sql)sp_removedistpublisherdbreplication (sp_removedistpublisherdbreplication (Transact-SQL)
Transact-sql)sp_repladdcolumn (sp_repladdcolumn (Transact-SQL)
sp_replcmds(Transact-SQL)sp_replcmds (Transact-SQL)
Transact-sql)sp_replcounters (sp_replcounters (Transact-SQL)
sp_repldone(Transact-SQL)sp_repldone (Transact-SQL)
Transact-sql)sp_repldropcolumn (sp_repldropcolumn (Transact-SQL)
Transact-sql)sp_replflush (sp_replflush (Transact-SQL)
Transact-sql)sp_replication_agent_checkup (sp_replication_agent_checkup (Transact-SQL)
sp_replicationdboption(Transact-SQL)sp_replicationdboption (Transact-SQL)
Transact-sql)sp_replmonitorchangepublicationthreshold (sp_replmonitorchangepublicationthreshold (Transact-SQL)
Transact-sql)sp_replmonitorhelpmergesession (sp_replmonitorhelpmergesession (Transact-SQL)
Transact-sql)sp_replmonitorhelpmergesessiondetail (sp_replmonitorhelpmergesessiondetail (Transact-SQL)
Transact-sql)sp_replmonitorhelppublication (sp_replmonitorhelppublication (Transact-SQL)
Transact-sql)sp_replmonitorhelppublicationthresholds (sp_replmonitorhelppublicationthresholds (Transact-SQL)
Transact-sql)sp_replmonitorhelppublisher (sp_replmonitorhelppublisher (Transact-SQL)
Transact-sql)sp_replmonitorhelpsubscription (sp_replmonitorhelpsubscription (Transact-SQL)
Transact-sql)sp_replmonitorsubscriptionpendingcmds (sp_replmonitorsubscriptionpendingcmds (Transact-SQL)
Transact-sql)sp_replqueuemonitor (sp_replqueuemonitor (Transact-SQL)
Transact-sql)sp_replrestart (sp_replrestart (Transact-SQL)
Transact-sql)sp_replsetoriginator (sp_replsetoriginator (Transact-SQL)
Transact-sql)sp_replshowcmds (sp_replshowcmds (Transact-SQL)
Transact-sql)sp_repltrans (sp_repltrans (Transact-SQL)
Transact-sql)sp_requestpeerresponse (sp_requestpeerresponse (Transact-SQL)
Transact-sql)sp_requestpeertopologyinfo (sp_requestpeertopologyinfo (Transact-SQL)
Transact-sql)sp_resetsnapshotdeliveryprogress (sp_resetsnapshotdeliveryprogress (Transact-SQL)
Transact-sql)sp_restoredbreplication (sp_restoredbreplication (Transact-SQL)
Transact-sql)sp_restoremergeidentityrange (sp_restoremergeidentityrange (Transact-SQL)
Transact-sql)sp_resyncmergesubscription (sp_resyncmergesubscription (Transact-SQL)
Transact-sql)sp_revoke_publication_access (sp_revoke_publication_access (Transact-SQL)
Transact-sql)sp_schemafilter (sp_schemafilter (Transact-SQL)
Transact-sql)sp_script_synctran_commands (sp_script_synctran_commands (Transact-SQL)
Transact-sql)sp_scriptdynamicupdproc (sp_scriptdynamicupdproc (Transact-SQL)
Transact-sql)sp_scriptpublicationcustomprocs (sp_scriptpublicationcustomprocs (Transact-SQL)
Transact-sql)sp_scriptsubconflicttable (sp_scriptsubconflicttable (Transact-SQL)
Transact-sql)sp_setdefaultdatatypemapping (sp_setdefaultdatatypemapping (Transact-SQL)
Transact-sql)sp_setreplfailovermode (sp_setreplfailovermode (Transact-SQL)
Transact-sql)sp_setsubscriptionxactseqno (sp_setsubscriptionxactseqno (Transact-SQL)
Transact-sql)sp_showpendingchanges (sp_showpendingchanges (Transact-SQL)
Transact-sql)sp_showrowreplicainfo (sp_showrowreplicainfo (Transact-SQL)
Transact-sql)sp_startpublication_snapshot (sp_startpublication_snapshot (Transact-SQL)
Transact-sql)sp_subscription_cleanup (sp_subscription_cleanup (Transact-SQL)
Transact-sql)sp_table_validation (sp_table_validation (Transact-SQL)
Transact-sql)sp_unregister_custom_scripting (sp_unregister_custom_scripting (Transact-SQL)
Transact-sql)sp_unregistercustomresolver (sp_unregistercustomresolver (Transact-SQL)
Transact-sql)sp_update_agent_profile (sp_update_agent_profile (Transact-SQL)
Transact-sql)sp_validate_redirected_publisher (sp_validate_redirected_publisher (Transact-SQL)
Transact-sql)sp_validate_replica_hosts_as_publishers (sp_validate_replica_hosts_as_publishers (Transact-SQL)
Transact-sql)sp_validatemergepublication (sp_validatemergepublication (Transact-SQL)
Transact-sql)sp_validatemergesubscription (sp_validatemergesubscription (Transact-SQL)
Transact-sql)sp_vupgrade_mergeobjects (sp_vupgrade_mergeobjects (Transact-SQL)
Transact-sql)sp_vupgrade_replication (sp_vupgrade_replication (Transact-SQL)

참고 항목See Also

Replication Management Objects Concepts Replication Management Objects Concepts
복제 프로그래밍 개념Replication Programming Concepts