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 ?