Share via

sys.dm_cdc_errors (Transact-SQL)

Returns one row for each error encountered during the change data capture log scan session.

Column name

Data type

Description

session_id

int

ID of the session.

0 = the error did not occur within a log scan session.

phase_number

int

Number indicating the phase the session was in at the time the error occurred. For a description of each phase, see sys.dm_cdc_log_scan_sessions (Transact-SQL).

entry_time

datetime

The date and time the error was logged. This value corresponds to the timestamp in the SQL error log.

error_number

int

ID of the error message.

error_severity

int

Severity level of the message, between 1 and 25.

error_state

int

State number of the error.

error_message

nvarchar(1024)

Message text of the error.

start_lsn

nvarchar(23)

Starting LSN value of the rows being processed when the error occurred.

0 = the error did not occur within a log scan session.

begin_lsn

nvarchar(23)

Beginning LSN value of the transaction being processed when the error occurred.

0 = the error did not occur within a log scan session.

sequence_value

nvarchar(23)

LSN value of the rows being processed when the error occurred.

0 = the error did not occur within a log scan session.

Remarks

sys.dm_cdc_errors contains error information for the previous 32 sessions.

Permissions

Requires VIEW DATABASE STATE permission to query the sys.dm_cdc_errors dynamic management view. For more information about permissions on dynamic management views, see Dynamic Management Views and Functions (Transact-SQL).