TechNet
Export (0) Print
Expand All

sys.dm_cdc_errors (Transact-SQL)

 

Updated: June 10, 2016

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 nameData typeDescription
session_idintID of the session.

0 = the error did not occur within a log scan session.
phase_numberintNumber 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_timedatetimeThe date and time the error was logged. This value corresponds to the timestamp in the SQL error log.
error_numberintID of the error message.
error_severityintSeverity level of the message, between 1 and 25.
error_stateintState number of the error.
error_messagenvarchar(1024)Message text of the error.
start_lsnnvarchar(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_lsnnvarchar(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_valuenvarchar(23)LSN value of the rows being processed when the error occurred.

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

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

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

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

Community Additions

ADD
Show:
© 2016 Microsoft