Bagikan melalui

Prosedur tersimpan replikasi (Transact-SQL)

  • Artikel

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