MSrepl_errors

Transact-SQL Reference

Transact-SQL Reference

MSrepl_errors

The MSrepl_errors table contains rows with extended Distribution Agent and Merge Agent failure information. This table is stored in the distribution database.

Column name Data type Description
id int ID of the error.
time datetime Time the error occurred.
error_type_id int Reserved for future use.
source_type_id int Error source type ID.
source_name nvarchar(100) Name of the error source.
error_code sysname Error code.
error_text ntext Error message.
xact_seqno varbinary(16) Starting tranaction log sequence number of the failed execution batch. Used only by the Distribution Agents, this is the transaction log sequence number of the first transaction in the failed execution batch.
command_id int Command ID of the failed execution batch. Used only by the Distribution Agents, this is the command ID of the first command in the failed execution batch.