Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSrepl_errors (Transact-SQL)

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

Reserved for future use.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.