msmerge-history-transact-sql.md

title	MSmerge_history (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSmerge_history_TSQL MSmerge_history
dev_langs	TSQL
helpviewer_keywords	MSmerge_history system table
ms.assetid	936195ad-ca07-41a8-a1a0-6699b6e63403
author	stevestein
ms.author	sstein

MSmerge_history (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)