Редактиране

Споделяне чрез


Replication stored procedures (Transact-SQL)

Applies to: SQL Server Azure SQL Database

Replication system stored procedures are documented and available as a method for accomplishing one-time tasks, such as implementing replication, and for using in batch files and scripts.

For more information on how to program most of the common replication tasks using replication stored procedures, see Replication System Stored Procedures Concepts.

Important

Only the replication stored procedures documented in SQL Server Books Online are supported. Undocumented stored procedures are only for the use of internal replication components and shouldn't be used to administer replication.

sp_add_agent_parameter
sp_add_agent_profile
sp_addarticle
sp_adddistpublisher
sp_adddistributiondb
sp_adddistributor
sp_adddynamicsnapshot_job
sp_addlogreader_agent
sp_addmergealternatepublisher
sp_addmergearticle
sp_addmergefilter
sp_addmergepartition
sp_addmergepublication
sp_addmergepullsubscription
sp_addmergepullsubscription_agent
sp_addmergepushsubscription_agent
sp_addmergesubscription
sp_addpublication
sp_addpublication_snapshot
sp_addpullsubscription
sp_addpullsubscription_agent
sp_addpushsubscription_agent
sp_addqreader_agent
sp_addqueued_artinfo
sp_addscriptexec
sp_addsubscriber
sp_addsubscriber_schedule
sp_addsubscription
sp_addsynctriggers
sp_addtabletocontents
sp_adjustpublisheridentityrange
sp_article_validation
sp_articlecolumn
sp_articlefilter
sp_articleview
sp_attachsubscription
sp_browsemergesnapshotfolder
sp_browsereplcmds
sp_browsesnapshotfolder
sp_change_agent_parameter
sp_change_agent_profile
sp_change_subscription_properties
sp_changearticle
sp_changearticlecolumndatatype
sp_changedistpublisher
sp_changedistributiondb
sp_changedistributor_password
sp_changedistributor_property
sp_changedynamicsnapshot_job
sp_changelogreader_agent
sp_changemergearticle
sp_changemergefilter
sp_changemergepublication
sp_changemergepullsubscription
sp_changemergesubscription
sp_changepublication
sp_changepublication_snapshot
sp_changeqreader_agent
sp_changereplicationserverpasswords
sp_changesubscriber
sp_changesubscriber_schedule
sp_changesubscription
sp_changesubscriptiondtsinfo
sp_changesubstatus
sp_check_dynamic_filters
sp_check_for_sync_trigger
sp_check_join_filter
sp_check_subset_filter
sp_configure_peerconflictdetection
sp_copymergesnapshot
sp_copysnapshot
sp_copysubscription
sp_deletemergeconflictrow
sp_deletepeerrequesthistory
sp_deletetracertokenhistory
sp_drop_agent_parameter
sp_drop_agent_profile
sp_dropanonymousagent
sp_droparticle
sp_dropdistpublisher
sp_dropdistributiondb
sp_dropdistributor
sp_dropdynamicsnapshot_job
sp_dropmergealternatepublisher
sp_dropmergearticle
sp_dropmergefilter
sp_dropmergepartition
sp_dropmergepublication
sp_dropmergepullsubscription
sp_dropmergesubscription
sp_droppublication
sp_droppullsubscription
sp_dropsubscriber
sp_dropsubscription
sp_dsninfo
sp_enumcustomresolvers
sp_enumdsn
sp_enumeratependingschemachanges
sp_expired_subscription_cleanup
sp_generatefilters
sp_get_distributor
sp_get_redirected_publisher
sp_getagentparameterlist
sp_getdefaultdatatypemapping
sp_getmergedeletetype
sp_getqueuedrows
sp_getsubscriptiondtspackagename
sp_gettopologyinfo
sp_grant_publication_access
sp_help_agent_default
sp_help_agent_parameter
sp_help_agent_profile
sp_helparticle
sp_helparticlecolumns

sp_helparticledts
sp_helpdatatypemap
sp_helpdistpublisher
sp_helpdistributiondb
sp_helpdistributor
sp_helpdistributor_properties
sp_helpdynamicsnapshot_job
sp_helplogreader_agent
sp_helpmergealternatepublisher
sp_helpmergearticle
sp_helpmergearticlecolumn
sp_helpmergearticleconflicts
sp_helpmergeconflictrows
sp_helpmergedeleteconflictrows
sp_helpmergefilter
sp_helpmergepartition
sp_helpmergepublication
sp_helpmergepullsubscription
sp_helpmergesubscription
sp_help_peerconflictdetection
sp_helppeerrequests
sp_helppeerresponses
sp_helppublication
sp_helppublication_snapshot
sp_helppullsubscription
sp_helpqreader_agent
sp_helpreplfailovermode
sp_helpreplicationdboption
sp_helpreplicationoption
sp_helpsubscriberinfo
sp_helpsubscription
sp_helpsubscription_properties
sp_helpsubscriptionerrors
sp_helptracertokenhistory
sp_helptracertokens
sp_helpxactsetjob
sp_ivindexhasnullcols
sp_link_publication
sp_lookupcustomresolver
sp_markpendingschemachange
sp_marksubscriptionvalidation
sp_mergearticlecolumn
sp_mergecleanupmetadata
sp_mergedummyupdate
sp_mergemetadataretentioncleanup
sp_mergesubscription_cleanup
sp_MSchange_distribution_agent_properties
sp_MSchange_logreader_agent_properties
sp_MSchange_merge_agent_properties
sp_MSchange_snapshot_agent_properties
sp_posttracertoken
sp_publication_validation
sp_publisherproperty
sp_redirect_publisher
sp_refreshsubscriptions
sp_register_custom_scripting
sp_registercustomresolver
sp_reinitmergepullsubscription
sp_reinitmergesubscription
sp_reinitpullsubscription
sp_reinitsubscription
sp_removedbreplication
sp_removedistpublisherdbreplication
sp_repladdcolumn
sp_replcmds
sp_replcounters
sp_repldone
sp_repldropcolumn
sp_replflush
sp_replication_agent_checkup
sp_replicationdboption
sp_replmonitorchangepublicationthreshold
sp_replmonitorhelpmergesession
sp_replmonitorhelpmergesessiondetail
sp_replmonitorhelppublication
sp_replmonitorhelppublicationthresholds
sp_replmonitorhelppublisher
sp_replmonitorhelpsubscription
sp_replmonitorsubscriptionpendingcmds
sp_replqueuemonitor
sp_replrestart
sp_replsetoriginator
sp_replshowcmds
sp_repltrans
sp_requestpeerresponse
sp_requestpeertopologyinfo
sp_resetsnapshotdeliveryprogress
sp_restoredbreplication
sp_restoremergeidentityrange
sp_resyncmergesubscription
sp_revoke_publication_access
sp_schemafilter
sp_script_synctran_commands
sp_scriptdynamicupdproc
sp_scriptpublicationcustomprocs
sp_scriptsubconflicttable
sp_setdefaultdatatypemapping
sp_setreplfailovermode
sp_setsubscriptionxactseqno
sp_showpendingchanges
sp_showrowreplicainfo
sp_startpublication_snapshot
sp_subscription_cleanup
sp_table_validation
sp_unregister_custom_scripting
sp_unregistercustomresolver
sp_update_agent_profile
sp_validate_redirected_publisher
sp_validate_replica_hosts_as_publishers
sp_validatemergepublication
sp_validatemergesubscription
sp_vupgrade_mergeobjects
sp_vupgrade_replication