GilaMonster,

Will turning on Auditing on the secondary server capture the changes?

Thanks,

Sorry you already answered my question in your previous post, about transaction logs not recorded while restoring!

On to thinking for other solutions....

Thanks

We are ok with it being in Standby and Read Only. So applying Transaction Log Backup files in itself doesn't create any "Transactions" and hence CDC wont capture it?

Thanks,

Hello Tom,

We have a similar situation. The Production database developed and maintained by a different contractor does not have CDC turned on. We were brainstorming with a solution to apply...