Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Balthrop Field Level Auditing using Change Data Capture – Part 2 RE: Field Level Auditing using Change Data Capture – Part 2

  • November 15, 2011 at 7:29 am

    #1407874

    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] @FromLSNDate='2011-11-15 09:18:39.000', @ToLSNDate='2011-11-15 09:23:40.700'

    I still get no data back!