Hi,

There is someone who can also check this stored procedure : "spgGetCDCContract" ?

Thanks

Hi David,

have you still investigate in that stored procedure: "spgGetCDCContract", why I could not get data back when I try what you asked me to do?

Thanks

When I try this:

-- get the @FromLSNDate date

use [CDCDW]

go

exec [spgGetCDCHistoryLastLSNDate] @cdcTable='dbo_contract'

go

-- get the @ToLSNDate date

use [CDCDemo]

go

exec [spgGetCDCMaxLSNDate]

go

-- substitute the dates returned above here and see if this returns results

exec [spgGetCDCContract]...

Hi David,

Thanks to reply, yes I get data back when I run this last query against CDCDemo database:

DECLARE @from_lsn binary(10), @to_lsn binary(10)

SET @from_lsn =

sys.fn_cdc_get_min_lsn('dbo_contract')

SET @to_lsn = sys.fn_cdc_get_max_lsn()

SELECT *...

Hi David

I did try several times your demonstration but I couldn't get the stagingCdcContract Table populate with data.

When I run the stored procedure "Exec [dbo].[sPgGetCDCContract] @FromLSNDate=?, @ToLSNDate=?" I...

Yes you right, my data files were not into the correct location.

Thanks 😉

Hi,

You have done a very good demonstration.

I did try what you have done in my visual studio 2005 but it doesn't work. It seems like the vb script...