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