Skip to content

Latest commit

 

History

History
36 lines (31 loc) · 1.76 KB

msmerge-history-transact-sql.md

File metadata and controls

36 lines (31 loc) · 1.76 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
MSmerge_history (Transact-SQL)
MSmerge_history (Transact-SQL)
VanMSFT
vanto
03/06/2017
sql
replication
reference
MSmerge_history_TSQL
MSmerge_history
MSmerge_history system table
TSQL

MSmerge_history (Transact-SQL)

[!INCLUDE 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)