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 Programming Replication Using System Stored Procedures.

ms174364.note(it-it,SQL.90).gifImportante:
Sono supportate solo le stored procedure per la replica documentate 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_help_publication_access (Transact-SQL)

sp_add_agent_profile (Transact-SQL)

sp_helparticle (Transact-SQL)

sp_addarticle (Transact-SQL)

sp_helparticlecolumns (Transact-SQL)

sp_adddistpublisher (Transact-SQL)

sp_helparticledts (Transact-SQL)

sp_adddistributiondb (Transact-SQL)

sp_helpdatatypemap (Transact-SQL)

sp_adddistributor (Transact-SQL)

sp_helpdistpublisher (Transact-SQL)

sp_adddynamicsnapshot_job (Transact-SQL)

sp_helpdistributiondb (Transact-SQL)

sp_addlogreader_agent (Transact-SQL)

sp_helpdistributor (Transact-SQL)

sp_addmergealternatepublisher (Transact-SQL)

sp_helpdistributor_properties (Transact-SQL)

sp_addmergearticle (Transact-SQL)

sp_helpdynamicsnapshot_job (Transact-SQL)

sp_addmergefilter (Transact-SQL)

sp_helplogreader_agent (Transact-SQL)

sp_addmergepartition (Transact-SQL)

sp_helpmergealternatepublisher (Transact-SQL)

sp_addmergepublication (Transact-SQL)

sp_helpmergearticle (Transact-SQL)

sp_addmergepullsubscription (Transact-SQL)

sp_helpmergearticlecolumn (Transact-SQL)

sp_addmergepullsubscription_agent (Transact-SQL)

sp_helpmergearticleconflicts (Transact-SQL)

sp_addmergepushsubscription_agent (Transact-SQL)

sp_helpmergeconflictrows (Transact-SQL)

sp_addmergesubscription (Transact-SQL)

sp_helpmergedeleteconflictrows (Transact-SQL)

sp_addpublication (Transact-SQL)

sp_helpmergefilter (Transact-SQL)

sp_addpublication_snapshot (Transact-SQL)

sp_helpmergepartition (Transact-SQL)

sp_addpullsubscription (Transact-SQL)

sp_helpmergepublication (Transact-SQL)

sp_addpullsubscription_agent (Transact-SQL)

sp_helpmergepullsubscription (Transact-SQL)

sp_addpushsubscription_agent (Transact-SQL)

sp_helpmergesubscription (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_copymergesnapshot (Transact-SQL)

sp_repldropcolumn (Transact-SQL)

sp_copysnapshot (Transact-SQL)

sp_replflush (Transact-SQL)

sp_copysubscription (Transact-SQL)

sp_replication_agent_checkup (Transact-SQL)

sp_deletemergeconflictrow (Transact-SQL)

sp_replicationdboption (Transact-SQL)

sp_deletepeerrequesthistory (Transact-SQL)

sp_replmonitorchangepublicationthreshold (Transact-SQL)

sp_deletetracertokenhistory (Transact-SQL)

sp_replmonitorhelpmergesession (Transact-SQL)

sp_disableagentoffload (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_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_enableagentoffload (Transact-SQL)

sp_scriptsubconflicttable (Transact-SQL)

sp_enumcustomresolvers (Transact-SQL)

sp_setdefaultdatatypemapping (Transact-SQL)

sp_enumdsn (Transact-SQL)

sp_setreplfailovermode (Transact-SQL)

sp_enumeratependingschemachanges (Transact-SQL)

sp_setsubscriptionxactseqno (Transact-SQL)

sp_expired_subscription_cleanup (Transact-SQL)

sp_showpendingchanges (Transact-SQL)

sp_generatefilters (Transact-SQL)

sp_showrowreplicainfo (Transact-SQL)

sp_get_distributor (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_grant_publication_access (Transact-SQL)

sp_validatemergepublication (Transact-SQL)

sp_help_agent_default (Transact-SQL)

sp_validatemergesubscription (Transact-SQL)

sp_help_agent_parameter (Transact-SQL)

sp_vupgrade_mergeobjects (Transact-SQL)

sp_help_agent_profile (Transact-SQL)

sp_vupgrade_replication (Transact-SQL)

Vedere anche

Altre risorse

Programming with Replication Management Objects
Planning for Replication Programming

Guida in linea e informazioni

Assistenza su SQL Server 2005