Procédures stockées de réplication (Transact-SQL)

Les procédures stockées du système de réplication sont documentées et disponibles en tant que méthode pour accomplir des tâches qui s'exécutent une fois, comme la mise en œuvre de la réplication, et pour être utilisées dans des fichiers de commandes et des scripts. Lorsque vous voulez ajouter le contrôle par programme de la réplication à une application ou accomplir des tâches de réplication répétées, telles que la synchronisation des abonnements, il est préférable d'utiliser l'interface de programmation fournie par Replication Management Objects (RMO).

La documentation en ligne de SQL Server fournit des exemples de la manière de programmer la plupart des tâches de réplication avec les procédures stockées Transact-SQL. Pour plus d'informations, consultez Programming Replication Using System Stored Procedures.

Important :
Seules les procédures stockées de réplication documentées dans la documentation en ligne de SQL Server sont prises en charge. Les procédures stockées non documentées sont uniquement destinées à l'utilisation de composants de réplication internes et ne doivent pas être utilisées pour administrer la réplication.

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)

Voir aussi

Autres ressources

Programming with Replication Management Objects
Planning for Replication Programming

Aide et Informations

Assistance sur SQL Server 2005