MSmerge_articlehistory (Transact-SQL)
Applies to: 
SQL Server
The MSmerge_articlehistory table tracks changes made to articles during a Merge Agent synchronization session, with one row for each article to which changes were made. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| session_id | int | The ID of a Merge Agent job session in the MSmerge_sessions system table. |
| phase_id | int | The phase of the synchronization session, which can be one of the following: 1 = Upload. 2 = Download. 4 = Clean-up. 5 = Shutdown. 6 = Schema changes. 7 = BCP. |
| article_name | sysname | The name of the article to which changes were made. |
| start_time | datetime | The time when the agent began processing the article. |
| duration | int | The length of time that the agent processed an article, in seconds. |
| inserts | int | The number of inserts that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
| updates | int | The number of updates that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
| deletes | int | The number of deletes that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
| conflicts | int | The number of conflicts that occurred during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
| conflicts_resolved | int | The number of conflicts that occurred during synchronization that were resolved. This value will increment during the synchronization process, and the ending value represents the total number. |
| rows_retried | int | The number of failed rows that were retried during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
| percent_complete | decimal | The percentage of the total synchronization time that the Merge Agent spent on the article during a session. This value is NULL until the session is complete. |
| estimated_changes | int | An estimate of the number of row changes that must be applied to the article. |
| relative_cost | decimal | The time spent applying changes for this article versus the total time for the entire session. |
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for