Export (0) Print
Expand All

cdc.lsn_time_mapping (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft