Change Data Capture - sys.dm_cdc_errors

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

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).

See Also

sys.dm_cdc_log_scan_sessions (Transact-SQL)
sys.dm_repl_traninfo (Transact-SQL)