SQLTeam.com | Weblogs | Forums

Error while EXECUTE sys.sp_cdc_enable_table


#1

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


#2

Does the account you ran the proc from have the permissions necessary to do the above?


#3

Yes i have permission.
The issue is resolved by restarting the computer :slightly_smiling:
Thank you