Unfortunately I could not find the cause, even using the profiler.

Versão: 10.0.2531.0

Service Pack: SP1

Edição: Enterprise Edition (64-bit)

Hi ALZDBA,

Stop in job_capture and executed the script below:

select * into bkp_lsn_time_mapping from cdc.lsn_time_mapping

go

truncate table cdc.lsn_time_mapping

go

Start in job_capture and executed the script below:

insert into cdc.lsn_time_mapping

select * from bkp_lsn_time_mapping

where start_lsn not...

Hi,

Problem solved! 😀

I will check the book

Thank you!