msmerge-metadataaction-request-transact-sql.md

title	MSmerge_metadataaction_request (Transact-SQL)
description	MSmerge_metadataaction_request (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	03/03/2017
ms.service	sql
ms.subservice	replication
ms.topic	reference
f1_keywords	MSmerge_metadataaction_request MSmerge_metadataaction_request_TSQL
helpviewer_keywords	MSmerge_metadataaction_request system table
dev_langs	TSQL

MSmerge_metadataaction_request (Transact-SQL)

[!INCLUDE SQL Server]

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