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.