複寫資料表 (Transact-SQL)

複寫拓撲是由複寫系統資料表所支援。當使用者資料庫被設定為發行者或訂閱者時，複寫便會將系統資料表加入資料庫中。當使用者資料庫從複寫拓撲中移除時，也會一併移除這些資料表。如需有關使用系統資料表的一般規則，請參閱＜系統資料表 (Transact-SQL)＞。

複寫資料表

下列是複寫所用的系統資料表清單，這些系統資料表是根據資料庫加以分組。

master 資料庫中的複寫資料表

MSreplication_options (Transact-SQL)

msdb 資料庫中的複寫資料表

MSagentparameterlist	MSdbms_map
MSdbms	MSreplmonthresholdmetrics
MSdbms_datatype	sysreplicationalerts
MSdbms_datatype_mapping

散發資料庫中的複寫資料表

MSagent_parameters	MSpublicationthresholds
MSagent_profiles	MSpublisher_databases
MSarticles	MSreplication_objects
MScached_peer_lsns	MSreplication_subscriptions
MSdistpublishers	MSrepl_commands
MSdistribution_agents	MSrepl_errors
MSdistribution_history	MSrepl_originators
MSdistributiondbs	MSrepl_transactions
MSdistributor	MSrepl_version
MSlogreader_agents	MSsnapshot_agents
MSlogreader_history	MSsnapshot_history
MSmerge_agents	MSsubscriber_info
MSmerge_history	MSsubscriber_schedule
MSmerge_sessions	MSsubscriptions
MSmerge_subscriptions	MSsubscription_properties
MSpublication_access	MStracer_history
MSpublications	MStracer_tokens

散發資料庫中的這些資料表用於非 SQL Server 發行者中的複寫資料。如需詳細資訊，請參閱＜非 SQL Server 發行者＞。

IHarticles	IHpublishercolumnindexes
IHcolumns	IHpublishercolumns
IHconstrainttypes	IHpublisherconstraints
IHindextypes	IHpublisherindexes
IHindextypes	IHpublishers
IHpublications	IHpublishertables
IHpublishercolumnconstraints	IHsubscriptions

發行集資料庫中的複寫資料表

MSdynamicsnapshotjobs	MSpeer_request
MSdynamicsnapshotviews	MSpeer_response
MSmerge_altsyncpartners	MSpub_identity_range
MSmerge_conflicts_info	sysarticlecolumns
MSmerge_contents	sysarticles
MSmerge_current_partition_mappings	sysarticleupdates
MSmerge_dynamic_snapshots	sysmergearticlecolumns
MSmerge_errorlineage	sysmergearticles
MSmerge_generation_partition_mappings	sysmergepartitioninfo
MSmerge_genhistory	sysmergepublications
MSmerge_identity_range	sysmergeschemaarticles
MSmerge_metadataaction_request	sysmergeschemachange
MSmerge_partition_groups	sysmergesubscriptions
MSmerge_past_partition_mappings	sysmergesubsetfilters
MSmerge_replinfo	syspublications
MSmerge_settingshistory	sysschemaarticles
MSmerge_tombstone	syssubscriptions
MSpeer_lsns	systranschemas

訂閱資料庫中的複寫資料表

MSdynamicsnapshotjobs	MSmerge_settingshistory
MSdynamicsnapshotviews	MSmerge_tombstone
MSmerge_altsyncpartners	MSpeer_lsns (Transact-SQL)
MSmerge_conflicts_info	MSrepl_queuedtraninfo
MSmerge_contents	MSsnapshotdeliveryprogress
MSmerge_current_partition_mappings	MSsubscription_properties
MSmerge_dynamic_snapshots	sysmergearticlecolumns
MSmerge_errorlineage	sysmergearticles
MSmerge_generation_partition_mappings	sysmergepartitioninfo
MSmerge_genhistory	sysmergepublications
MSmerge_identity_range	sysmergeschemaarticles
MSmerge_metadataaction_request	sysmergeschemachange
MSmerge_partition_groups	sysmergesubscriptions
MSmerge_past_partition_mappings	sysmergesubsetfilters
MSmerge_replinfo	systranschemas

請參閱

參考

複寫檢視 (Transact-SQL)

其他資源

How to: Configure Publishing and Distribution (Replication Transact-SQL Programming)
How to: Disable Publishing and Distribution (Replication Transact-SQL Programming)

說明及資訊

取得 SQL Server 2005 協助