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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply