cdc-lsn-time-mapping-transact-sql.md

title	cdc.lsn_time_mapping (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	cdc.lsn_time_mapping cdc.lsn_time_mapping_TSQL
dev_langs	TSQL
helpviewer_keywords	cdc.lsn_time_mapping
ms.assetid	1cb7aedc-48a4-486e-9b91-d30c4bd4084e
author	stevestein
ms.author	sstein

cdc.lsn_time_mapping (Transact-SQL)

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

Returns one row for each transaction having rows in a change table. This table is used to map between log sequence number (LSN) commit values and the time the transaction committed. Entries may also be logged for which there are no change tables entries. This allows the table to record the completion of LSN processing in periods of low or no change activity.

We recommend that you do not query the system tables directly. Instead, execute the sys.fn_cdc_map_lsn_to_time (Transact-SQL) and sys.fn_cdc_map_time_to_lsn (Transact-SQL) system functions.

Column name	Data type	Description
start_lsn	binary(10)	LSN of the committed transaction.
tran_begin_time	datetime	Time that the transaction associated with the LSN began.
tran_end_time	datetime	Time that the transaction ended.
tran_id	varbinary(10)	ID of the transaction.

See Also

The Transaction Log (SQL Server)
cdc.<capture_instance>_CT (Transact-SQL)