• so if the source table doesn't have either pk or unique index.. what will be syntax to enable the table?

    is it

    USE Db

    GO

    EXEC sys.sp_cdc_enable_table

    @source_schema = N'DBO',

    @source_name = N'tbl_Name',

    @role_name = NULL;

    GO

    Or we need to specify some value for @supports_net_changes

    USE Db

    GO

    EXEC sys.sp_cdc_enable_table

    @source_schema = N'DBO',

    @source_name = N'tbl_Name',

    @role_name = NULL

    @supports_net_changes = ??;

    GO

    Am attempting CDC for the first time.. please point out if am missing something.

    TIA