MSmerge_history (Transact-SQL)

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 stored in the distribution database.

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

The set if the history row can be overwritten.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance