Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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 nameData typeDescription
session_idintThe ID of the Merge Agent job.
agent_idintThe ID of the Merge Agent.
commentsnvarchar(255)The message text.
error_idintThe ID of an error in the MSrepl_errors system table.
timestamptimestampThe timestamp column of this table.
updatable_rowbitSet to 1 if the history row can be overwritten.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

© 2016 Microsoft