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