共用方式為


複寫資料表 (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 協助