Stored procedure per la replica (Transact-SQL)

Le stored procedure di sistema per la replica documentate sono progettate per singole esecuzioni di attività specifiche, come l'implementazione della replica, e per l'utilizzo in file batch e script. Per programmare funzionalità di controllo della replica da integrare in un'applicazione o eseguire attività di replica ripetitive, come la sincronizzazione delle sottoscrizioni, è consigliabile utilizzare le interfacce di programmazione offerte dal modello RMO (Replication Management Objects).

Nella documentazione in linea di SQL Server sono disponibili esempi per la programmazione della maggior parte delle attività di replica comuni tramite stored procedure Transact-SQL. Per ulteriori informazioni, vedere Concetti di base relativi alle stored procedure del sistema di replica.

Importante
Sono supportate solo le stored procedure di replica indicate nella documentazione in linea di SQL Server. Le stored procedure non documentate sono destinate esclusivamente all'utilizzo in componenti di replica interni e non dovrebbero essere utilizzate per l'amministrazione delle funzionalità di replica.

sp_add_agent_parameter (Transact-SQL)	sp_helparticle (Transact-SQL)
sp_add_agent_profile (Transact-SQL)	sp_helparticlecolumns (Transact-SQL)
sp_addarticle (Transact-SQL)	sp_helparticledts (Transact-SQL)
sp_adddistpublisher (Transact-SQL)	sp_helpdatatypemap (Transact-SQL)
sp_adddistributiondb (Transact-SQL)	sp_helpdistpublisher (Transact-SQL)
sp_adddistributor (Transact-SQL)	sp_helpdistributiondb (Transact-SQL)
sp_adddynamicsnapshot_job (Transact-SQL)	sp_helpdistributor (Transact-SQL)
sp_addlogreader_agent (Transact-SQL)	sp_helpdistributor_properties (Transact-SQL)
sp_addmergealternatepublisher (Transact-SQL)	sp_helpdynamicsnapshot_job (Transact-SQL)
sp_addmergearticle (Transact-SQL)	sp_helplogreader_agent (Transact-SQL)
sp_addmergefilter (Transact-SQL)	sp_helpmergealternatepublisher (Transact-SQL)
sp_addmergepartition (Transact-SQL)	sp_helpmergearticle (Transact-SQL)
sp_addmergepublication (Transact-SQL)	sp_helpmergearticlecolumn (Transact-SQL)
sp_addmergepullsubscription (Transact-SQL)	sp_helpmergearticleconflicts (Transact-SQL)
sp_addmergepullsubscription_agent (Transact-SQL)	sp_helpmergeconflictrows (Transact-SQL)
sp_addmergepushsubscription_agent (Transact-SQL)	sp_helpmergedeleteconflictrows (Transact-SQL)
sp_addmergesubscription (Transact-SQL)	sp_helpmergefilter (Transact-SQL)
sp_addpublication (Transact-SQL)	sp_helpmergepartition (Transact-SQL)
sp_addpublication_snapshot (Transact-SQL)	sp_helpmergepublication (Transact-SQL)
sp_addpullsubscription (Transact-SQL)	sp_helpmergepullsubscription (Transact-SQL)
sp_addpullsubscription_agent (Transact-SQL)	sp_helpmergesubscription (Transact-SQL)
sp_addpushsubscription_agent (Transact-SQL)	sp_help_peerconflictdetection (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_mergecleanupmetadata (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_configure_peerconflictdetection (Transact-SQL)	sp_repldropcolumn (Transact-SQL)
sp_copymergesnapshot (Transact-SQL)	sp_replflush (Transact-SQL)
sp_copysnapshot (Transact-SQL)	sp_replication_agent_checkup (Transact-SQL)
sp_copysubscription (Transact-SQL)	sp_replicationdboption (Transact-SQL)
sp_deletemergeconflictrow (Transact-SQL)	sp_replmonitorchangepublicationthreshold (Transact-SQL)
sp_deletepeerrequesthistory (Transact-SQL)	sp_replmonitorhelpmergesession (Transact-SQL)
sp_deletetracertokenhistory (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_requestpeertopologyinfo (Transact-SQL)
sp_dropmergepublication (Transact-SQL)	sp_resetsnapshotdeliveryprogress (Transact-SQL)
sp_dropmergepullsubscription (Transact-SQL)	sp_restoredbreplication (Transact-SQL)
sp_dropmergesubscription (Transact-SQL)	sp_restoremergeidentityrange (Transact-SQL)
sp_droppublication (Transact-SQL)	sp_resyncmergesubscription (Transact-SQL)
sp_droppullsubscription (Transact-SQL)	sp_revoke_publication_access (Transact-SQL)
sp_dropsubscriber (Transact-SQL)	sp_schemafilter (Transact-SQL)
sp_dropsubscription (Transact-SQL)	sp_script_synctran_commands (Transact-SQL)
sp_dsninfo (Transact-SQL)	sp_scriptdynamicupdproc (Transact-SQL)
sp_enumcustomresolvers (Transact-SQL)	sp_scriptpublicationcustomprocs (Transact-SQL)
sp_enumdsn (Transact-SQL)	sp_scriptsubconflicttable (Transact-SQL)
sp_enumeratependingschemachanges (Transact-SQL)	sp_setdefaultdatatypemapping (Transact-SQL)
sp_expired_subscription_cleanup (Transact-SQL)	sp_setreplfailovermode (Transact-SQL)
sp_generatefilters (Transact-SQL)	sp_setsubscriptionxactseqno (Transact-SQL)
sp_get_distributor (Transact-SQL)	sp_showpendingchanges (Transact-SQL)
sp_getagentparameterlist (Transact-SQL)	sp_showrowreplicainfo (Transact-SQL)
sp_getdefaultdatatypemapping (Transact-SQL)	sp_startpublication_snapshot (Transact-SQL)
sp_getmergedeletetype (Transact-SQL)	sp_subscription_cleanup (Transact-SQL)
sp_getqueuedrows (Transact-SQL)	sp_table_validation (Transact-SQL)
sp_getsubscriptiondtspackagename (Transact-SQL)	sp_unregister_custom_scripting (Transact-SQL)
sp_gettopologyinfo (Transact-SQL)	sp_unregistercustomresolver (Transact-SQL)
sp_grant_publication_access (Transact-SQL)	sp_update_agent_profile (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)
sp_help_publication_access (Transact-SQL)	sp_vupgrade_replication (Transact-SQL)

Vedere anche

Concetti

Concetti di base relativi a RMO (Replication Management Objects)

Concetti di base relativi alla programmazione della replica