MSmerge_history (Transact-SQL)
Applies to: SQL Server
The MSmerge_history table contains history rows with detailed descriptions of the outcomes of previous Merge Agent job sessions. This table contains one row for each line of agent output. This table is used in the distribution database and in each subscription database. In the distribution database, it contains history for all merge publications and subscriptions that use the Distributor. In each subscription database, it contains the history for publications to which the Subscriber is subscribed.
Column name | Data type | Description |
---|---|---|
session_id | int | The ID of the Merge Agent job. |
agent_id | int | The ID of the Merge Agent. |
comments | nvarchar(255) | The message text. |
error_id | int | The ID of an error in the MSrepl_errors system table. |
timestamp | timestamp | The timestamp column of this table. |
updatable_row | bit | Set to 1 if the history row can be overwritten. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for