MSmerge_metadataaction_request (Transact-SQL)

The MSmerge_metadataaction_request table stores one row for each compensating action that is required. Using Web synchronization, if an error occurs and the synchronization must be retried, an entry is made into MSmerge_metadataaction_request. During the upload phase of the subsequent merge, requests for all articles belonging to the publication being synchronized are retrieved from this table and uploaded. When the synchronization is successfully completed, the corresponding row in the MSmerge_metadataaction_request table is deleted. This table is stored at the Publisher in the publication database and at the Subscriber in the subscription database.

Column name Data type Description

tablenick

int

The nickname of the published table.

rowguid

uniqueidentifier

The row identifier for the given row.

action

tinyint

Identifies the compensating action required.

generation

bigint

The value of the generation for which the compensating action is needed.

changed

int

Internal-use only.

See Also

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

How Merge Replication Works
Web Synchronization for Merge Replication

Help and Information

Getting SQL Server 2005 Assistance