Transact-SQL Reference
MSmerge_history
The MSmerge_history table contains history rows for previous updates to Subscriber. This table is stored in the distribution database.
Column name | Data type | Description |
---|---|---|
agent_id | int | ID of the agent. |
runstatus | int | Running status:
1 = Start |
start_time | datetime | Time execution of the job began. |
time | datetime | Time of this history entry. |
duration | int | Cumulative duration, in seconds, of this session. |
comments | nvarchar(255) | Message text. |
delivery_time | int | Number of seconds it took to apply a batch of changes. |
delivery_rate | float | Average delivered commands per second. |
publisher_insertcount | int | Number of inserts at the Publisher. |
publisher_updatecount | int | Number of updates at the Publisher. |
publisher_deletecount | int | Number of deletes at the Publisher. |
publisher_conflictcount | int | Number of conflicts at the Publisher. |
subscriber_insertcount | int | Number of inserts at the Subscriber. |
subscriber_updatecount | int | Number of updates at the Subscriber. |
subscriber_deletecount | int | Number of deletes at the Subscriber. |
subscriber_conflictcount | int | Number of conflicts at the Subscriber. |
error_id | int | ID of an error in the MSrepl_error system table. |
timestamp | timestamp | Timestamp column of this table. |
updateable_row | bit | Set if the history row can be overwritten. |