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

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

SQL?Server 온라인 설명서는 Transact-SQL 저장 프로시저를 사용하여 대부분의 일반적인 복제 작업을 프로그래밍하는 방법에 대한 예를 제공합니다. 자세한 내용은 Programming Replication Using System Stored Procedures를 참조하십시오.

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

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_add_targetservergroup(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)	p_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_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_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)	s 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)

참고 항목

관련 자료

Programming with Replication Management Objects
Planning for Replication Programming

도움말 및 정보

SQL Server 2005 지원 받기