MSrepl_errors (Transact-SQL)

 

Applies To: SQL Server

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

Column nameData typeDescription
idintThe ID of the error.
timedatetimeThe time the error occurred.
error_type_idintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
source_type_idintThe error source type ID.
source_namenvarchar(100)The name of the error source.
error_codesysnameThe error code.
error_textntextThe error message.
xact_seqnovarbinary(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_idintThe 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_idintThe ID of the agent session in which the error occurred.

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

Community Additions

ADD
Show: