'CDC not enable in table level,login with administrator also
Msg 22832, Level 16, State 1, Procedure sys.sp_cdc_enable_table_internal, Line 659 [Batch Start Line 12].
Could not update the metadata that indicates table [dbo].[Customers] is enabled for Change Data Capture.
The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''.
The error returned was 22836:
'Could not update the metadata for database Test to indicate that a Change Data Capture job has been added.
The failure occurred when executing the command 'sp_add_jobstep_internal'. The error returned was 50000: 'profile name is not valid'.
Use the action and error to determine the cause of the failure and resubmit the request.'. Use the action and error to determine the cause of the failure and resubmit the request
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
