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 11, 2011 at 7:13 am

    #1406243

    There is an error in [CDCDemo].[dbo].[spgGetCDCContract]

    replace

    SET @from_lsn = sys.fn_cdc_map_time_to_lsn('largest greater than', @FromLSNDate);

    by

    SET @from_lsn = sys.fn_cdc_map_time_to_lsn('smallest greater than', @FromLSNDate);