March 19, 2018 at 11:38 pm
I'm trying to set up CDC and I get the following error when running the following script
exec sys.sp_cdc_enable_table
@source_schema = N'khtest',
@source_name = N'dbo.test',
@role_name = NULL,
@supports_net_changes = 1
GO
Msg 22988, Level 16, State 1, Procedure sp_cdc_enable_table, Line 24 [Batch Start Line 0]
This instance of SQL Server is the Standard Edition (64-bit). Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions.
I wasn't aware it wasn't available on standard edition. Any help would be great
Kris
March 20, 2018 at 7:10 am
Kris-155042 - Monday, March 19, 2018 11:38 PMI'm trying to set up CDC and I get the following error when running the following scriptexec sys.sp_cdc_enable_table
@source_schema = N'khtest',
@source_name = N'dbo.test',
@role_name = NULL,
@supports_net_changes = 1
GO
Msg 22988, Level 16, State 1, Procedure sp_cdc_enable_table, Line 24 [Batch Start Line 0]
This instance of SQL Server is the Standard Edition (64-bit). Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions.
I wasn't aware it wasn't available on standard edition. Any help would be great
Have you installed 2016 SP1?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 20, 2018 at 7:56 am
Yes
Kris
March 20, 2018 at 8:31 am
Kris-155042 - Tuesday, March 20, 2018 7:56 AMYes
OK, the 2016 Edition Comparison suggests that it should work with SP1 installed, so I am out of ideas.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply