MSmerge_history

Transact-SQL Reference

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
2 = Succeed
3 = In progress
4 = Idle
5 = Retry
6 = Fail

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.