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.|