Prosedur tersimpan replikasi (Transact-SQL)
Berlaku untuk:SQL ServerAzure SQL Database
Prosedur tersimpan sistem replikasi didokumentasikan dan tersedia sebagai metode untuk menyelesaikan tugas satu kali, seperti menerapkan replikasi, dan untuk digunakan dalam file batch dan skrip.
Untuk informasi selengkapnya tentang cara memprogram sebagian besar tugas replikasi umum menggunakan prosedur tersimpan replikasi, lihat Konsep prosedur tersimpan Sistem Replikasi.
Penting
Hanya prosedur tersimpan replikasi yang didokumenkan di SQL Server Books Online yang didukung. Prosedur tersimpan yang tidak terdokumentasi hanya untuk penggunaan komponen replikasi internal dan tidak boleh digunakan untuk mengelola replikasi.
sp_add_agent_parameter (T-SQL)
sp_add_agent_profile (T-SQL)
sp_addarticle (T-SQL)
sp_adddistpublisher (T-SQL)
sp_adddistributiondb (T-SQL)
sp_adddistributor (T-SQL)
sp_adddynamicsnapshot_job (T-SQL)
sp_addlogreader_agent (T-SQL)
sp_addmergealternatepublisher (T-SQL)
sp_addmergearticle (T-SQL)
sp_addmergefilter (T-SQL)
sp_addmergepartition (T-SQL)
sp_addmergepublication (T-SQL)
sp_addmergepullsubscription (T-SQL)
sp_addmergepullsubscription_agent (T-SQL)
sp_addmergepushsubscription_agent (T-SQL)
sp_addmergesubscription (T-SQL)
sp_addpublication (T-SQL)
sp_addpublication_snapshot (T-SQL)
sp_addpullsubscription (T-SQL)
sp_addpullsubscription_agent (T-SQL)
sp_addpushsubscription_agent (T-SQL)
sp_addqreader_agent (T-SQL)
sp_addqueued_artinfo (T-SQL)
sp_addscriptexec (T-SQL)
sp_addsubscriber (T-SQL)
sp_addsubscriber_schedule (T-SQL)
sp_addsubscription (T-SQL)
sp_addsynctriggers (T-SQL)
sp_addtabletocontents (T-SQL)
sp_adjustpublisheridentityrange (T-SQL)
sp_article_validation (T-SQL)
sp_articlecolumn (T-SQL)
sp_articlefilter (T-SQL)
sp_articleview (T-SQL)
sp_attachsubscription (T-SQL)
sp_browsemergesnapshotfolder (T-SQL)
sp_browsereplcmds (T-SQL)
sp_browsesnapshotfolder (T-SQL)
sp_change_agent_parameter (T-SQL)
sp_change_agent_profile (T-SQL)
sp_change_subscription_properties (T-SQL)
sp_changearticle (T-SQL)
sp_changearticlecolumndatatype (T-SQL)
sp_changedistpublisher (T-SQL)
sp_changedistributiondb (T-SQL)
sp_changedistributor_password (T-SQL)
sp_changedistributor_property (T-SQL)
sp_changedynamicsnapshot_job (T-SQL)
sp_changelogreader_agent (T-SQL)
sp_changemergearticle (T-SQL)
sp_changemergefilter (T-SQL)
sp_changemergepublication (T-SQL)
sp_changemergepullsubscription (T-SQL)
sp_changemergesubscription (T-SQL)
sp_changepublication (T-SQL)
sp_changepublication_snapshot (T-SQL)
sp_changeqreader_agent (T-SQL)
sp_changereplicationserverpasswords (T-SQL)
sp_changesubscriber (T-SQL)
sp_changesubscriber_schedule (T-SQL)
sp_changesubscription (T-SQL)
sp_changesubscriptiondtsinfo (T-SQL)
sp_changesubstatus (T-SQL)
sp_check_dynamic_filters (T-SQL)
sp_check_for_sync_trigger (T-SQL)
sp_check_join_filter (T-SQL)
sp_check_subset_filter (T-SQL)
sp_configure_peerconflictdetection (T-SQL)
sp_copymergesnapshot (T-SQL)
sp_copysnapshot (T-SQL)
sp_copysubscription (T-SQL)
sp_deletemergeconflictrow (T-SQL)
sp_deletepeerrequesthistory (T-SQL)
sp_deletetracertokenhistory (T-SQL)
sp_drop_agent_parameter (T-SQL)
sp_drop_agent_profile (T-SQL)
sp_dropanonymousagent (T-SQL)
sp_droparticle (T-SQL)
sp_dropdistpublisher (T-SQL)
sp_dropdistributiondb (T-SQL)
sp_dropdistributor (T-SQL)
sp_dropdynamicsnapshot_job (T-SQL)
sp_dropmergealternatepublisher (T-SQL)
sp_dropmergearticle (T-SQL)
sp_dropmergefilter (T-SQL)
sp_dropmergepartition (T-SQL)
sp_dropmergepublication (T-SQL)
sp_dropmergepullsubscription (T-SQL)
sp_dropmergesubscription (T-SQL)
sp_droppublication (T-SQL)
sp_droppullsubscription (T-SQL)
sp_dropsubscriber (T-SQL)
sp_dropsubscription (T-SQL)
sp_dsninfo (T-SQL)
sp_enumcustomresolvers (T-SQL)
sp_enumdsn (T-SQL)
sp_enumeratependingschemachanges (T-SQL)
sp_expired_subscription_cleanup (T-SQL)
sp_generatefilters (T-SQL)
sp_get_distributor (T-SQL)
sp_get_redirected_publisher (T-SQL)
sp_getagentparameterlist (T-SQL)
sp_getdefaultdatatypemapping (T-SQL)
sp_getmergedeletetype (T-SQL)
sp_getqueuedrows (T-SQL)
sp_getsubscriptiondtspackagename (T-SQL)
sp_gettopologyinfo (T-SQL)
sp_grant_publication_access (T-SQL)
sp_help_agent_default (T-SQL)
sp_help_agent_parameter (T-SQL)
sp_help_agent_profile (T-SQL)
sp_helparticle (T-SQL)
sp_helparticlecolumns (T-SQL)
sp_helparticledts (T-SQL)
sp_helpdatatypemap (T-SQL)
sp_helpdistpublisher (T-SQL)
sp_helpdistributiondb (T-SQL)
sp_helpdistributor (T-SQL)
sp_helpdistributor_properties (T-SQL)
sp_helpdynamicsnapshot_job (T-SQL)
sp_helplogreader_agent (T-SQL)
sp_helpmergealternatepublisher (T-SQL)
sp_helpmergearticle (T-SQL)
sp_helpmergearticlecolumn (T-SQL)
sp_helpmergearticleconflicts (T-SQL)
sp_helpmergeconflictrows (T-SQL)
sp_helpmergedeleteconflictrows (T-SQL)
sp_helpmergefilter (T-SQL)
sp_helpmergepartition (T-SQL)
sp_helpmergepublication (T-SQL)
sp_helpmergepullsubscription (T-SQL)
sp_helpmergesubscription (T-SQL)
sp_help_peerconflictdetection (T-SQL)
sp_helppeerrequests (T-SQL)
sp_helppeerresponses (T-SQL)
sp_helppublication (T-SQL)
sp_helppublication_snapshot (T-SQL)
sp_helppullsubscription (T-SQL)
sp_helpqreader_agent (T-SQL)
sp_helpreplfailovermode (T-SQL)
sp_helpreplicationdboption (T-SQL)
sp_helpreplicationoption (T-SQL)
sp_helpsubscriberinfo (T-SQL)
sp_helpsubscription (T-SQL)
sp_helpsubscription_properties (T-SQL)
sp_helpsubscriptionerrors (T-SQL)
sp_helptracertokenhistory (T-SQL)
sp_helptracertokens (T-SQL)
sp_helpxactsetjob (T-SQL)
sp_ivindexhasnullcols (T-SQL)
sp_link_publication (T-SQL)
sp_lookupcustomresolver (T-SQL)
sp_markpendingschemachange (T-SQL)
sp_marksubscriptionvalidation (T-SQL)
sp_mergearticlecolumn (T-SQL)
sp_mergecleanupmetadata (T-SQL)
sp_mergedummyupdate (T-SQL)
sp_mergemetadataretentioncleanup (T-SQL)
sp_mergesubscription_cleanup (T-SQL)
sp_MSchange_distribution_agent_properties (T-SQL)
sp_MSchange_logreader_agent_properties (T-SQL)
sp_MSchange_merge_agent_properties (T-SQL)
sp_MSchange_snapshot_agent_properties (T-SQL)
sp_posttracertoken (T-SQL)
sp_publication_validation (T-SQL)
sp_publisherproperty (T-SQL)
sp_redirect_publisher (T-SQL)
sp_refreshsubscriptions (T-SQL)
sp_register_custom_scripting (T-SQL)
sp_registercustomresolver (T-SQL)
sp_reinitmergepullsubscription (T-SQL)
sp_reinitmergesubscription (T-SQL)
sp_reinitpullsubscription (T-SQL)
sp_reinitsubscription (T-SQL)
sp_removedbreplication (T-SQL)
sp_removedistpublisherdbreplication (T-SQL)
sp_repladdcolumn (T-SQL)
sp_replcmds (T-SQL)
sp_replcounters (T-SQL)
sp_repldone (T-SQL)
sp_repldropcolumn (T-SQL)
sp_replflush (T-SQL)
sp_replication_agent_checkup (T-SQL)
sp_replicationdboption (T-SQL)
sp_replmonitorchangepublicationthreshold (T-SQL)
sp_replmonitorhelpmergesession (T-SQL)
sp_replmonitorhelpmergesessiondetail (T-SQL)
sp_replmonitorhelppublication (T-SQL)
sp_replmonitorhelppublicationthresholds (T-SQL)
sp_replmonitorhelppublisher (T-SQL)
sp_replmonitorhelpsubscription (T-SQL)
sp_replmonitorsubscriptionpendingcmds (T-SQL)
sp_replqueuemonitor (T-SQL)
sp_replrestart (T-SQL)
sp_replsetoriginator (T-SQL)
sp_replshowcmds (T-SQL)
sp_repltrans (T-SQL)
sp_requestpeerresponse (T-SQL)
sp_requestpeertopologyinfo (T-SQL)
sp_resetsnapshotdeliveryprogress (T-SQL)
sp_restoredbreplication (T-SQL)
sp_restoremergeidentityrange (T-SQL)
sp_resyncmergesubscription (T-SQL)
sp_revoke_publication_access (T-SQL)
sp_schemafilter (T-SQL)
sp_script_synctran_commands (T-SQL)
sp_scriptdynamicupdproc (T-SQL)
sp_scriptpublicationcustomprocs (T-SQL)
sp_scriptsubconflicttable (T-SQL)
sp_setdefaultdatatypemapping (T-SQL)
sp_setreplfailovermode (T-SQL)
sp_setsubscriptionxactseqno (T-SQL)
sp_showpendingchanges (T-SQL)
sp_showrowreplicainfo (T-SQL)
sp_startpublication_snapshot (T-SQL)
sp_subscription_cleanup (T-SQL)
sp_table_validation (T-SQL)
sp_unregister_custom_scripting (T-SQL)
sp_unregistercustomresolver (T-SQL)
sp_update_agent_profile (T-SQL)
sp_validate_redirected_publisher (T-SQL)
sp_validate_replica_hosts_as_publishers (T-SQL)
sp_validatemergepublication (T-SQL)
sp_validatemergesubscription (T-SQL)
sp_vupgrade_mergeobjects (T-SQL)
sp_vupgrade_replication (T-SQL)
Konten terkait
Saran dan Komentar
https://aka.ms/ContentUserFeedback.
Segera hadir: Sepanjang tahun 2024 kami akan menghentikan penggunaan GitHub Issues sebagai mekanisme umpan balik untuk konten dan menggantinya dengan sistem umpan balik baru. Untuk mengetahui informasi selengkapnya, lihat:Kirim dan lihat umpan balik untuk