MSrepl_errors (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 The ID of the error.
time datetime The time the error occurred.
error_type_id int Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
source_type_id int The error source type ID.
source_name nvarchar(100) The name of the error source.
error_code sysname The error code.
error_text ntext The error message.
xact_seqno varbinary(16) The starting transaction 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 The 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.
session_id int The ID of the agent session in which the error occurred.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)