[SQL Server]所有replication相關的Stored Procedure

有關資料庫的討論, 都可以在這發表哦~~
回覆文章
頭像
tim
文章: 1288
註冊時間: 2008年 11月 26日, 00:49

[SQL Server]所有replication相關的Stored Procedure

文章 tim » 2009年 7月 29日, 17:03

http://msdn.microsoft.com/en-us/library/ms174364.aspx

包含:

sp_add_agent_parameter
sp_helparticle
sp_add_agent_profile
sp_helparticlecolumns
sp_addarticle
sp_helparticledts
sp_adddistpublisher
sp_helpdatatypemap
sp_adddistributiondb
sp_helpdistpublisher
sp_adddistributor
sp_helpdistributiondb
sp_adddynamicsnapshot_job
sp_helpdistributor
sp_addlogreader_agent
sp_helpdistributor_properties
sp_addmergealternatepublisher
sp_helpdynamicsnapshot_job
sp_addmergearticle
sp_helplogreader_agent
sp_addmergefilter
sp_helpmergealternatepublisher
sp_addmergepartition
sp_helpmergearticle
sp_addmergepublication
sp_helpmergearticlecolumn
sp_addmergepullsubscription
sp_helpmergearticleconflicts
sp_addmergepullsubscription_agent
sp_helpmergeconflictrows
sp_addmergepushsubscription_agent
sp_helpmergedeleteconflictrows
sp_addmergesubscription
sp_helpmergefilter
sp_addpublication
sp_helpmergepartition
sp_addpublication_snapshot
sp_helpmergepublication
sp_addpullsubscription
sp_helpmergepullsubscription
sp_addpullsubscription_agent
sp_helpmergesubscription
sp_addpushsubscription_agent
sp_help_peerconflictdetection
sp_addqreader_agent
sp_helppeerrequests
sp_addqueued_artinfo
sp_helppeerresponses
sp_addscriptexec
sp_helppublication
sp_addsubscriber
sp_helppublication_snapshot
sp_addsubscriber_schedule
sp_helppullsubscription
sp_addsubscription
sp_helpqreader_agent
sp_addsynctriggers
sp_helpreplfailovermode
sp_addtabletocontents
sp_helpreplicationdboption
sp_adjustpublisheridentityrange
sp_helpreplicationoption
sp_article_validation
sp_helpsubscriberinfo
sp_articlecolumn
sp_helpsubscription
sp_articlefilter
sp_helpsubscription_properties
sp_articleview
sp_helpsubscriptionerrors
sp_attachsubscription
sp_helptracertokenhistory
sp_browsemergesnapshotfolder
sp_helptracertokens
sp_browsereplcmds
sp_helpxactsetjob
sp_browsesnapshotfolder
sp_ivindexhasnullcols
sp_change_agent_parameter
sp_link_publication
sp_change_agent_profile
sp_lookupcustomresolver
sp_change_subscription_properties
sp_markpendingschemachange
sp_changearticle
sp_marksubscriptionvalidation
sp_changearticlecolumndatatype
sp_mergearticlecolumn
sp_changedistpublisher
sp_mergecleanupmetadata
sp_changedistributiondb
sp_mergedummyupdate
sp_changedistributor_password
sp_mergemetadataretentioncleanup
sp_changedistributor_property
sp_mergesubscription_cleanup
sp_changedynamicsnapshot_job
sp_MSchange_distribution_agent_properties
sp_changelogreader_agent
sp_MSchange_logreader_agent_properties
sp_changemergearticle
sp_MSchange_merge_agent_properties
sp_changemergefilter
sp_MSchange_snapshot_agent_properties
sp_changemergepublication
sp_posttracertoken
sp_changemergepullsubscription
sp_publication_validation
sp_changemergesubscription
sp_publisherproperty
sp_changepublication
sp_refreshsubscriptions
sp_changepublication_snapshot
sp_register_custom_scripting
sp_changeqreader_agent
sp_registercustomresolver
sp_changereplicationserverpasswords
sp_reinitmergepullsubscription
sp_changesubscriber
sp_reinitmergesubscription
sp_changesubscriber_schedule
sp_reinitpullsubscription
sp_changesubscription
sp_reinitsubscription
sp_changesubscriptiondtsinfo
sp_removedbreplication
sp_changesubstatus
sp_removedistpublisherdbreplication
sp_check_dynamic_filters
sp_repladdcolumn
sp_check_for_sync_trigger
sp_replcmds
sp_check_join_filter
sp_replcounters
sp_check_subset_filter
sp_repldone
sp_configure_peerconflictdetection
sp_repldropcolumn
sp_copymergesnapshot
sp_replflush
sp_copysnapshot
sp_replication_agent_checkup
sp_copysubscription
*sp_replicationdboption
sp_deletemergeconflictrow
sp_replmonitorchangepublicationthreshold
sp_deletepeerrequesthistory
sp_replmonitorhelpmergesession
sp_deletetracertokenhistory
sp_replmonitorhelpmergesessiondetail
sp_drop_agent_parameter
sp_replmonitorhelppublication
sp_drop_agent_profile
sp_replmonitorhelppublicationthresholds
sp_dropanonymousagent
sp_replmonitorhelppublisher
sp_droparticle
sp_replmonitorhelpsubscription
sp_dropdistpublisher
sp_replmonitorsubscriptionpendingcmds
sp_dropdistributiondb
sp_replqueuemonitor
sp_dropdistributor
sp_replrestart
sp_dropdynamicsnapshot_job
sp_replsetoriginator
sp_dropmergealternatepublisher
sp_replshowcmds
sp_dropmergearticle
sp_repltrans
sp_dropmergefilter
sp_requestpeerresponse
sp_dropmergepartition
sp_requestpeertopologyinfo
sp_dropmergepublication
sp_resetsnapshotdeliveryprogress
sp_dropmergepullsubscription
sp_restoredbreplication
sp_dropmergesubscription
sp_restoremergeidentityrange
sp_droppublication
sp_resyncmergesubscription
sp_droppullsubscription
sp_revoke_publication_access
sp_dropsubscriber
sp_schemafilter
sp_dropsubscription
sp_script_synctran_commands
sp_dsninfo
sp_scriptdynamicupdproc
sp_enumcustomresolvers
sp_scriptpublicationcustomprocs
sp_enumdsn
sp_scriptsubconflicttable
sp_enumeratependingschemachanges
sp_setdefaultdatatypemapping
sp_expired_subscription_cleanup
sp_setreplfailovermode
sp_generatefilters
sp_setsubscriptionxactseqno
sp_get_distributor
sp_showpendingchanges
sp_getagentparameterlist
sp_showrowreplicainfo
sp_getdefaultdatatypemapping
sp_startpublication_snapshot
sp_getmergedeletetype
sp_subscription_cleanup
sp_getqueuedrows
sp_table_validation
sp_getsubscriptiondtspackagename
sp_unregister_custom_scripting
sp_gettopologyinfo
sp_unregistercustomresolver
sp_grant_publication_access
sp_update_agent_profile
sp_help_agent_default
sp_validatemergepublication
sp_help_agent_parameter
sp_validatemergesubscription
sp_help_agent_profile
sp_vupgrade_mergeobjects
sp_help_publication_access
sp_vupgrade_replication
多多留言, 整理文章, 把經驗累積下來.....

回覆文章