Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't find table "cdc.lsn_time_mapping"

Tags:

sql-server

I'm working on a legacy system that have a call to this function (sys.fn_cdc_map_time_to_lsn), and I'm getting the following error:

Invalid object name 'cdc.lsn_time_mapping'

I couldn't find this table on Object Explorer. Is there any replacement for this function or do I need to have any special permission to access it?

Thanks in advance.

like image 407
BernardoMorais Avatar asked Jan 08 '23 05:01

BernardoMorais


1 Answers

As it turns out, CDC was not enabled for the OPs database. Enabling it will create this table (among other objects).

like image 190
Ben Thul Avatar answered Jan 18 '23 21:01

Ben Thul