Hi all
i have a problem while EXECUTE sys.sp_cdc_enable_table with it's paramters
EXECUTE sys.sp_cdc_enable_table @source_schema = N'dbo' , @source_name = N'ERP_Taxs' , @role_name ='db_owner',@supports_net_changes = 1;
the error is
Could not update the metadata that indicates table [dbo].[ERP_Taxs] is enabled for Change Data Capture. The failure occurred when executing the command 'sp_cdc_grant_select_on_change_enumeration_functions'. The error returned was 4617: 'Cannot grant, deny or revoke permissions to or from special roles.'. Use the action and error to determine the cause of the failure and resubmit the request.
I've already enabled CDC on my db using EXECUTE sys.sp_cdc_enable_db
and result was success
thanks all