MSmerge_metadataaction_request (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Web Synchronization for Merge Replication