Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Change Data Capture. Expand / Collapse
Posted Wednesday, July 24, 2013 11:19 AM


Group: General Forum Members
Last Login: Tuesday, January 5, 2016 1:14 PM
Points: 105, Visits: 485
I am trying to enable Change Data Capture on SQL Server 2008 R2 DB.
When I enable CDC on a table by using this SP sys.sp_cdc_enable_table
the Capture Job is not getting created....did some search about it and found out that
Capture job wont work on DB 's where transactional replication is enabled..

Is there a workaround for enabling CDC on Database where Transaction Replication is active ?
Post #1477179
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse