change-data-capture-sys-dm-cdc-errors.md

title	sys.dm_cdc_errors (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dm_cdc_errors_TSQL dm_cdc_errors sys.dm_cdc_errors sys.dm_cdc_errors_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_cdc_errors dynamic management view change data capture [SQL Server], error reporting
ms.assetid	898f2d76-9e63-45ef-94da-8034e86004ab
author	stevestein
ms.author	sstein

Change Data Capture - sys.dm_cdc_errors

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)