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

복제 시스템 저장 프로시저는 복제 구현과 같은 일회적인 태스크나 배치 파일이나 스크립트에서 사용할 수 있도록 문서화되고 사용됩니다. 복제에 대한 프로그래밍 제어를 응용 프로그램에 추가하거나 구독 동기화와 같은 반복적인 복제 태스크를 수행하려는 경우 RMO(복제 관리 개체)에서 제공하는 프로그래밍 인터페이스를 사용하는 것이 더 좋습니다.

SQL Server 온라인 설명서에서는 Transact-SQL 저장 프로시저를 사용하여 대부분의 일반적인 복제 태스크를 프로그래밍하는 방법에 대한 예를 제공합니다. 자세한 내용은 복제 시스템 저장 프로시저 개념를 참조하십시오.

중요 정보중요

SQL Server 온라인 설명서에 문서화된 복제 저장 프로시저만 지원됩니다. 문서화되지 않은 저장 프로시저는 내부 복제 구성 요소에서만 사용하기 위한 것이므로 복제 관리에 사용하면 안 됩니다.

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_add_targetservergroup(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)

p_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_update_schedule(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)

s 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)