I have the following values in a table . This table is stores CDC data ( as it was captured) from the original CDC table in the incremental order.
StartLSN , TransactionOperation
0x00001016000045D6001A , 2
0x00001016000046170016 ,3
0x00001016000046170016 ,4
But when I run the following query I get the null value
sys.fn_cdc_map_lsn_to_time(StartLsn)
How do I fix the problem?
Doesn't tell us much as we don't know the query you are running, what you are using for StartLSN.
I can run this and it works fine:
SELECT sys.fn_cdc_map_lsn_to_time(__$start_lsn) as ChangeTime, *
FROM cdc.dbo_TableWithChangeTracking_CT
Sue