Çoğaltma depolanan yordamlar (Transact-sql)

Makale
10/29/2012

Yineleme sistem saklı yordamları belgelenen ve çoğaltma, uygulama gibi bir seferlik görevlerini yerine getirmeye ve toplu iş dosyalarında ve komut dosyalarında kullanmak için bir yöntem olarak kullanılabilir. Programlı denetim çoğaltma uygulama eklemek veya abonelik eşitleme gibi yinelenen çoğaltma görevleri gerçekleştirmek istediğinizde daha iyi sağlanan Çoğaltma Yönetimi Nesneleri'ni (rmo) programlama arabirimleri kullanılarak yapılmaktadır.

SQL ServerÇevrimiçi Kitaplar en yaygın çoğaltma görevleri kullanarak program nasıl örnekleri sağlar Transact-SQLsaklı yordamlar. Daha fazla bilgi için, bkz. Yineleme sistem saklı yordamlar kavramları.

Önemli
Yalnızca çoğaltma depolanmış yordamları belgelenen SQL Serverçevrimiçi desteklenir. Belgesiz saklı yordamları iç çoğaltma bileşenleri yalnızca kullanım içindir ve çoğaltmayı yönetmek için kullanılmamalıdır.

sp_add_agent_parameter (Transact-sql)	sp_helparticledts (Transact-sql)
sp_add_agent_profile (Transact-sql)	sp_helpdatatypemap (Transact-sql)
eşdeğerdirsp_addarticle (Transact-sql)	sp_helpdistpublisher (Transact-sql)
sp_adddistpublisher (Transact-sql)	sp_helpdistributiondb (Transact-sql)
sp_adddistributiondb (Transact-sql)	sp_helpdistributor (Transact-sql)
eşdeğerdirsp_adddistributor (Transact-sql)	sp_helpdistributor_properties (Transact-sql)
sp_adddynamicsnapshot_job (Transact-sql)	sp_helpdynamicsnapshot_job (Transact-sql)
sp_addlogreader_agent (Transact-sql)	sp_helplogreader_agent (Transact-sql)
sp_addmergealternatepublisher (Transact-sql)	sp_helpmergealternatepublisher (Transact-sql)
yürütmesp_addmergearticle (Transact-sql)	eşdeğerdirsp_helpmergearticle (Transact-sql)
sp_addmergefilter (Transact-sql)	sp_helpmergearticlecolumn (Transact-sql)
sp_addmergepartition (Transact-sql)	sp_helpmergearticleconflicts (Transact-sql)
veyasp_addmergepublication (Transact-sql)	sp_helpmergeconflictrows (Transact-sql)
sp_addmergepullsubscription (Transact-sql)	sp_helpmergedeleteconflictrows (Transact-sql)
sp_addmergepullsubscription_agent (Transact-sql)	sp_helpmergefilter (Transact-sql)
sp_addmergepushsubscription_agent (Transact-sql)	sp_helpmergepartition (Transact-sql)
sp_addmergesubscription (Transact-sql)	eşdeğerdirsp_helpmergepublication (Transact-sql)
için yürütme eşdeğerdirsp_addpublication (Transact-sql)	eşdeğerdirsp_helpmergepullsubscription (Transact-sql)
sp_addpublication_snapshot (Transact-sql)	sp_helpmergesubscription (Transact-sql)
yürütme eşdeğerdirsp_addpullsubscription (Transact-sql)	sp_help_peerconflictdetectionEşler (Transact-sql)
yürütme eşdeğerdirsp_addpullsubscription_agent (Transact-sql)	sp_helppeerrequests (Transact-sql)
sp_addpushsubscription_agent (Transact-sql)	sp_helppeerresponses (Transact-sql)
sp_addqreader_agent (Transact-sql)	yürütme eşdeğerdirsp_helppublication (Transact-sql)
sp_addqueued_artinfo (Transact-sql)	sp_helppublication_snapshot (Transact-sql)
sp_addscriptexec (Transact-sql)	için yürütme eşdeğerdirsp_helppullsubscription (Transact-sql)
sp_addsubscriber (Transact-sql)	sp_helpqreader_agent (Transact-sql)
sp_addsubscriber_schedule (Transact-sql)	sp_helpreplfailovermode (Transact-sql)
sp_addsubscription (Transact-sql)	eşdeğerdirsp_helpreplicationdboption (Transact-sql)
sp_addsynctriggers (Transact-sql)	sp_helpreplicationoption (Transact-sql)
sp_addtabletocontents (Transact-sql)	sp_helpsubscriberinfo (Transact-sql)
sp_adjustpublisheridentityrange (Transact-sql)	sp_helpsubscription (Transact-sql)
sp_article_validation (Transact-sql)	sp_helpsubscription_properties (Transact-sql)
sp_articlecolumn (Transact-sql)	sp_helpsubscriptionerrors (Transact-sql)
sp_articlefilter (Transact-sql)	sp_helptracertokenhistory (Transact-sql)
sp_articleview (Transact-sql)	sp_helptracertokens (Transact-sql)
sp_attachsubscription (Transact-sql)	sp_helpxactsetjob (Transact-sql)
sp_browsemergesnapshotfolder (Transact-sql)	sp_ivindexhasnullcols (Transact-sql)
sp_browsereplcmds (Transact-sql)	sp_link_publication (Transact-sql)
sp_browsesnapshotfolder (Transact-sql)	sp_lookupcustomresolver (Transact-sql)
sp_change_agent_parameter (Transact-sql)	sp_markpendingschemachange (Transact-sql)
sp_change_agent_profile (Transact-sql)	sp_marksubscriptionvalidation (Transact-sql)
sp_change_subscription_properties (Transact-sql)	sp_mergearticlecolumn (Transact-sql)
veyasp_changearticle (Transact-sql)	Sp_mergecleanupmetadata (Transact-sql)
sp_changearticlecolumndatatype (Transact-sql)	sp_mergedummyupdate (Transact-sql)
sp_changedistpublisher (Transact-sql)	sp_mergemetadataretentioncleanup (Transact-sql)
sp_changedistributiondb (Transact-sql)	sp_mergesubscription_cleanup (Transact-sql)
sp_changedistributor_password (Transact-sql)	sp_MSchange_distribution_agent_properties (Transact-sql)
sp_changedistributor_property (Transact-sql)	sp_MSchange_logreader_agent_properties (Transact-sql)
eşdeğerdirsp_changedynamicsnapshot_job (Transact-sql)	sp_MSchange_merge_agent_properties (Transact-sql)
sp_changelogreader_agent (Transact-sql)	sp_MSchange_snapshot_agent_properties (Transact-sql)
sp_changemergearticle (Transact-sql)	sp_posttracertoken (Transact-sql)
sp_changemergefilter (Transact-sql)	sp_publication_validation (Transact-sql)
yürütmesp_changemergepublication (Transact-sql)	sp_publisherproperty (Transact-sql)
sp_changemergepullsubscription (Transact-sql)	sp_redirect_publisher (Transact-sql)
sp_changemergesubscription (Transact-sql)	sp_refreshsubscriptions (Transact-sql)
yürütmesp_changepublication (Transact-sql)	sp_register_custom_scripting (Transact-sql)
sp_changepublication_snapshot (Transact-sql)	sp_registercustomresolver (Transact-sql)
sp_changeqreader_agent (Transact-sql)	sp_reinitmergepullsubscription (Transact-sql)
sp_changereplicationserverpasswords (Transact-sql)	sp_reinitmergesubscription (Transact-sql)
sp_changesubscriber (Transact-sql)	sp_reinitpullsubscription (Transact-sql)
sp_changesubscriber_schedule (Transact-sql)	sp_reinitsubscription (Transact-sql)
sp_changesubscription (Transact-sql)	sp_removedbreplication (Transact-sql)
sp_changesubscriptiondtsinfo (Transact-sql)	sp_removedistpublisherdbreplication (Transact-sql)
sp_changesubstatus (Transact-sql)	sp_repladdcolumn (Transact-sql)
sp_check_dynamic_filters (Transact-sql)	sp_replcmds (Transact-sql)
sp_check_for_sync_trigger (Transact-sql)	sp_replcounters (Transact-sql)
sp_check_join_filter (Transact-sql)	sp_repldone (Transact-sql)
sp_check_subset_filter (Transact-sql)	sp_repldropcolumn (Transact-sql)
sp_configure_peerconflictdetection (Transact-sql)	sp_replflush (Transact-sql)
sp_copymergesnapshot (Transact-sql)	sp_replication_agent_checkup (Transact-sql)
sp_copysnapshot (Transact-sql)	sp_replicationdboption (Transact-sql)
sp_copysubscription (Transact-sql)	sp_replmonitorchangepublicationthreshold (Transact-sql)
sp_deletemergeconflictrow (Transact-sql)	sp_replmonitorhelpmergesession (Transact-sql)
sp_deletepeerrequesthistory (Transact-sql)	sp_replmonitorhelpmergesessiondetail (Transact-sql)
sp_deletetracertokenhistory (Transact-sql)	sp_replmonitorhelppublication (Transact-sql)
sp_drop_agent_parameter (Transact-sql)	sp_replmonitorhelppublicationthresholds (Transact-sql)
sp_drop_agent_profile (Transact-sql)	sp_replmonitorhelppublisher (Transact-sql)
sp_dropanonymousagent (Transact-sql)	sp_replmonitorhelpsubscription (Transact-sql)
sp_droparticle (Transact-sql)	sp_replmonitorsubscriptionpendingcmds (Transact-sql)
sp_dropdistpublisher (Transact-sql)	sp_replqueuemonitor (Transact-sql)
sp_dropdistributiondb (Transact-sql)	sp_replrestart (Transact-sql)
sp_dropdistributor (Transact-sql)	sp_replsetoriginator (Transact-sql)
eşdeğerdirsp_dropdynamicsnapshot_job (Transact-sql)	sp_replshowcmds (Transact-sql)
sp_dropmergealternatepublisher (Transact-sql)	sp_repltrans (Transact-sql)
sp_dropmergearticle (Transact-sql)	sp_requestpeerresponse (Transact-sql)
sp_dropmergefilter (Transact-sql)	sp_requestpeertopologyinfo (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_enumcustomresolvers (Transact-sql)	sp_scriptsubconflicttable (Transact-sql)
sp_enumdsn (Transact-sql)	sp_setdefaultdatatypemapping (Transact-sql)
sp_enumeratependingschemachanges (Transact-sql)	sp_setreplfailovermode (Transact-sql)
sp_expired_subscription_cleanup (Transact-sql)	sp_setsubscriptionxactseqno (Transact-sql)
sp_generatefilters (Transact-sql)	sp_showpendingchangesBirleştirme (Transact-sql)
eşdeğerdirsp_get_distributor (Transact-sql)	sp_showrowreplicainfo (Transact-sql)
sp_get_redirected_publisher (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_gettopologyinfo (Transact-sql)	sp_validate_redirected_publisher (Transact-sql)
sp_grant_publication_access (Transact-sql)	sp_validate_replica_hosts_as_publishers (Transact-sql)
sp_help_agent_default (Transact-sql)	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)
eşdeğerdirsp_helparticle (Transact-sql)	sp_vupgrade_replication (Transact-sql)
sp_helparticlecolumns (Transact-sql)

Ayrıca bkz.

Kavramlar

Çoğaltma Management Objects kavramları

Çoğaltma programlama kavramları

Çoğaltma depolanan yordamlar (Transact-sql)

Ayrıca bkz.

Kavramlar

Ek kaynaklar