Hi all,
SQL SERVER 2008 ENTERPISE EDITION
GG 11.2.0.1
As pre-requisite for sqlserver replication to oracle, I am enabling CDC on the sourcedb.
============
USE acrdb
go
exec sys.sp_cdc_enable_db
go
=============
But I got this error:
============
Msg 3930, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 178
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186
Could not update the metadata that indicates database ACRDB is enabled for Change Data Capture. The failure occurred when executing the command 'CREATE TABLE dbo.systranschemas'. The error returned was 262: 'CREATE TABLE permission denied in database 'ACRDB'.'. Use the action and error to determine the cause of the failure and resubmit the request.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db_internal, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 3998, Level 16, State 1, Line 1
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
============
Please help...
Thanks a lot,
zxy