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

  • 아티클

적용 대상:SQL ServerAzure SQL Database

복제 시스템 저장 프로시저는 복제본(replica) 구현과 같은 일회성 작업을 수행하고 배치 파일 및 스크립트에서 사용하기 위한 방법으로 문서화되고 사용할 수 있습니다.

복제본(replica)tion 저장 프로시저를 사용하여 대부분의 일반적인 복제본(replica)tion 작업을 프로그래밍하는 방법에 대한 자세한 내용은 복제 시스템 저장 프로시저 개념을 참조하세요.

Important

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

sp_add_agent_parameter(Transact-SQL)
sp_add_agent_profile(Transact-SQL)
sp_addarticle(Transact-SQL)
sp_adddistpublisher(Transact-SQL)
sp_adddistributiondb(Transact-SQL)
sp_adddistributor(Transact-SQL)
sp_adddynamic스냅샷_job(Transact-SQL)
sp_addlogreader_agent(Transact-SQL)
sp_addmergealternatepublisher(Transact-SQL)
sp_addmergearticle(Transact-SQL)
sp_addmergefilter(Transact-SQL)
sp_addmergepartition(Transact-SQL)
sp_addmergepublication(Transact-SQL)
sp_addmergepullsubscription(Transact-SQL)
sp_addmergepullsubscription_agent(Transact-SQL)
sp_addmergepushsubscription_agent(Transact-SQL)
sp_addmergesubscription(Transact-SQL)
sp_addpublication(Transact-SQL)
sp_addpublication_스냅샷(Transact-SQL)
sp_addpullsubscription(Transact-SQL)
sp_addpullsubscription_agent(Transact-SQL)
sp_addpushsubscription_agent(Transact-SQL)
sp_addqreader_agent(Transact-SQL)
sp_addqueued_artinfo(Transact-SQL)
sp_addscriptexec(Transact-SQL)
sp_addsubscriber(Transact-SQL)
sp_addsubscriber_schedule(Transact-SQL)
sp_addsubscription(Transact-SQL)
sp_addsynctriggers(Transact-SQL)
sp_addtabletocontents(Transact-SQL)
sp_adjustpublisheridentityrange(Transact-SQL)
sp_article_validation(Transact-SQL)
sp_articlecolumn(Transact-SQL)
sp_articlefilter(Transact-SQL)
sp_articleview(Transact-SQL)
sp_attachsubscription(Transact-SQL)
sp_browsemerge스냅샷folder(Transact-SQL)
sp_browsereplcmds(Transact-SQL)
sp_browse스냅샷folder(Transact-SQL)
sp_change_agent_parameter(Transact-SQL)
sp_change_agent_profile(Transact-SQL)
sp_change_subscription_properties(Transact-SQL)
sp_changearticle(Transact-SQL)
sp_changearticlecolumndatatype(Transact-SQL)
sp_changedistpublisher(Transact-SQL)
sp_changedistributiondb(Transact-SQL)
sp_changedistributor_password(Transact-SQL)
sp_changedistributor_property(Transact-SQL)
sp_changedynamic스냅샷_job(Transact-SQL)
sp_changelogreader_agent(Transact-SQL)
sp_changemergearticle(Transact-SQL)
sp_changemergefilter(Transact-SQL)
sp_changemergepublication(Transact-SQL)
sp_changemergepullsubscription(Transact-SQL)
sp_changemergesubscription(Transact-SQL)
sp_changepublication(Transact-SQL)
sp_changepublication_스냅샷(Transact-SQL)
sp_changeqreader_agent(Transact-SQL)
sp_change복제본(replica)tionserverpasswords(Transact-SQL)
sp_changesubscriber(Transact-SQL)
sp_changesubscriber_schedule(Transact-SQL)
sp_changesubscription(Transact-SQL)
sp_changesubscriptiondtsinfo(Transact-SQL)
sp_changesub상태(Transact-SQL)
sp_검사_dynamic_filters(Transact-SQL)
sp_검사_for_sync_trigger(Transact-SQL)
sp_검사_join_filter(Transact-SQL)
sp_검사_subset_filter(Transact-SQL)
sp_configure_peerconflictdetection(Transact-SQL)
sp_copymerge스냅샷(Transact-SQL)
sp_copy스냅샷(Transact-SQL)
sp_copysubscription(Transact-SQL)
sp_deletemergeconflictrow(Transact-SQL)
sp_deletepeerrequesthistory(Transact-SQL)
sp_deletetracertokenhistory(Transact-SQL)
sp_drop_agent_parameter(Transact-SQL)
sp_drop_agent_profile(Transact-SQL)
sp_dropanonymousagent(Transact-SQL)
sp_droparticle(Transact-SQL)
sp_dropdistpublisher(Transact-SQL)
sp_dropdistributiondb(Transact-SQL)
sp_dropdistributor(Transact-SQL)
sp_dropdynamic스냅샷_job(Transact-SQL)
sp_dropmergealternatepublisher(Transact-SQL)
sp_dropmergearticle(Transact-SQL)
sp_dropmergefilter(Transact-SQL)
sp_dropmergepartition(Transact-SQL)
sp_dropmergepublication(Transact-SQL)
sp_dropmergepullsubscription(Transact-SQL)
sp_dropmergesubscription(Transact-SQL)
sp_droppublication(Transact-SQL)
sp_droppullsubscription(Transact-SQL)
sp_dropsubscriber(Transact-SQL)
sp_dropsubscription(Transact-SQL)
sp_dsninfo(Transact-SQL)
sp_enumcustomresolvers(Transact-SQL)
sp_enumdsn(Transact-SQL)
sp_enumeratependingschemachanges(Transact-SQL)
sp_expired_subscription_클린up(Transact-SQL)
sp_generatefilters(Transact-SQL)
sp_get_distributor(Transact-SQL)
sp_get_redirected_publisher(Transact-SQL)
sp_getagentparameterlist(Transact-SQL)
sp_getdefaultdatatypemapping(Transact-SQL)
sp_getmergedeletetype(Transact-SQL)
sp_getqueuedrows(Transact-SQL)
sp_getsubscriptiondtspackagename(Transact-SQL)
sp_gettopologyinfo(Transact-SQL)
sp_grant_publication_access(Transact-SQL)
sp_help_agent_default(Transact-SQL)
sp_help_agent_parameter(Transact-SQL)
sp_help_agent_profile(Transact-SQL)
sp_helparticle(Transact-SQL)
sp_helparticlecolumns(Transact-SQL)

sp_helparticledts(Transact-SQL)
sp_helpdatatypemap(Transact-SQL)
sp_helpdistpublisher(Transact-SQL)
sp_helpdistributiondb(Transact-SQL)
sp_helpdistributor(Transact-SQL)
sp_helpdistributor_properties(Transact-SQL)
sp_helpdynamic스냅샷_job(Transact-SQL)
sp_helplogreader_agent(Transact-SQL)
sp_helpmergealternatepublisher(Transact-SQL)
sp_helpmergearticle(Transact-SQL)
sp_helpmergearticlecolumn(Transact-SQL)
sp_helpmergearticleconflicts(Transact-SQL)
sp_helpmergeconflictrows(Transact-SQL)
sp_helpmergedeleteconflictrows(Transact-SQL)
sp_helpmergefilter(Transact-SQL)
sp_helpmergepartition(Transact-SQL)
sp_helpmergepublication(Transact-SQL)
sp_helpmergepullsubscription(Transact-SQL)
sp_helpmergesubscription(Transact-SQL)
sp_help_peerconflictdetection(Transact-SQL)
sp_helppeerrequests(Transact-SQL)
sp_helppeerresponses(Transact-SQL)
sp_helppublication(Transact-SQL)
sp_helppublication_스냅샷(Transact-SQL)
sp_helppullsubscription(Transact-SQL)
sp_helpqreader_agent(Transact-SQL)
sp_helpreplfailovermode(Transact-SQL)
sp_help복제본(replica)tiondboption(Transact-SQL)
sp_help복제본(replica)tionoption(Transact-SQL)
sp_helpsubscriberinfo(Transact-SQL)
sp_helpsubscription(Transact-SQL)
sp_helpsubscription_properties(Transact-SQL)
sp_helpsubscriptionerrors(Transact-SQL)
sp_helptracertokenhistory(Transact-SQL)
sp_helptracertokens(Transact-SQL)
sp_helpxactsetjob(Transact-SQL)
sp_ivindexhasnullcols(Transact-SQL)
sp_link_publication(Transact-SQL)
sp_lookupcustomresolver(Transact-SQL)
sp_markpendingschemachange(Transact-SQL)
sp_marksubscriptionvalidation(Transact-SQL)
sp_mergearticlecolumn(Transact-SQL)
sp_merge클린upmetadata(Transact-SQL)
sp_mergedummyupdate(Transact-SQL)
sp_mergemetadataretention클린up(Transact-SQL)
sp_mergesubscription_클린up(Transact-SQL)
sp_MSchange_distribution_agent_properties(Transact-SQL)
sp_MSchange_logreader_agent_properties(Transact-SQL)
sp_MSchange_merge_agent_properties(Transact-SQL)
sp_MSchange_스냅샷_agent_properties(Transact-SQL)
sp_posttracertoken(Transact-SQL)
sp_publication_validation(Transact-SQL)
sp_publisherproperty(Transact-SQL)
sp_redirect_publisher(Transact-SQL)
sp_refreshsubscriptions(Transact-SQL)
sp_register_custom_scripting(Transact-SQL)
sp_registercustomresolver(Transact-SQL)
sp_reinitmergepullsubscription(Transact-SQL)
sp_reinitmergesubscription(Transact-SQL)
sp_reinitpullsubscription(Transact-SQL)
sp_reinitsubscription(Transact-SQL)
sp_removedb복제본(replica)tion(Transact-SQL)
sp_removedistpublisherdb복제본(replica)tion(Transact-SQL)
sp_repladdcolumn(Transact-SQL)
sp_replcmds(Transact-SQL)
sp_replcounters(Transact-SQL)
sp_repldone(Transact-SQL)
sp_repldropcolumn(Transact-SQL)
sp_replflush(Transact-SQL)
sp_복제본(replica)tion_agent_검사up(Transact-SQL)
sp_복제본(replica)tiondboption(Transact-SQL)
sp_replmonitorchangepublicationthreshold(Transact-SQL)
sp_replmonitorhelpmergesession(Transact-SQL)
sp_replmonitorhelpmergesessiondetail(Transact-SQL)
sp_replmonitorhelppublication(Transact-SQL)
sp_replmonitorhelppublicationthresholds(Transact-SQL)
sp_replmonitorhelppublisher(Transact-SQL)
sp_replmonitorhelpsubscription(Transact-SQL)
sp_replmonitorsubscriptionpendingcmds(Transact-SQL)
sp_replqueuemonitor(Transact-SQL)
sp_replrestart(Transact-SQL)
sp_replsetoriginator(Transact-SQL)
sp_replshowcmds(Transact-SQL)
sp_repltrans(Transact-SQL)
sp_requestpeerresponse(Transact-SQL)
sp_requestpeertopologyinfo(Transact-SQL)
sp_reset스냅샷deliveryprogress(Transact-SQL)
sp_restoredb복제본(replica)tion(Transact-SQL)
sp_restoremergeidentityrange(Transact-SQL)
sp_resyncmergesubscription(Transact-SQL)
sp_revoke_publication_access(Transact-SQL)
sp_schemafilter(Transact-SQL)
sp_script_synctran_commands(Transact-SQL)
sp_scriptdynamicupdproc(Transact-SQL)
sp_scriptpublicationcustomprocs(Transact-SQL)
sp_scriptsubconflicttable(Transact-SQL)
sp_setdefaultdatatypemapping(Transact-SQL)
sp_setreplfailovermode(Transact-SQL)
sp_setsubscriptionxactseqno(Transact-SQL)
sp_showpendingchanges(Transact-SQL)
sp_showrow복제본(replica)info(Transact-SQL)
sp_startpublication_스냅샷(Transact-SQL)
sp_subscription_클린up(Transact-SQL)
sp_table_validation(Transact-SQL)
sp_unregister_custom_scripting(Transact-SQL)
sp_unregistercustomresolver(Transact-SQL)
sp_update_agent_profile(Transact-SQL)
sp_validate_redirected_publisher(Transact-SQL)
sp_validate_복제본(replica)_hosts_as_publishers(Transact-SQL)
sp_validatemergepublication(Transact-SQL)
sp_validatemergesubscription(Transact-SQL)
sp_vupgrade_mergeobjects(Transact-SQL)
sp_vupgrade_복제본(replica)tion(Transact-SQL)

관련 콘텐츠