I am new to CDC and want to know if there is any problem in using CDC. I am targeting to use it for audit purpose i.e. Log activity using CDC and then show the same to user when needed. Does it record the exact changes to all fields in table in all cases
Asked
Active
Viewed 678 times
2
-
This question should probably be moved to server fault. – Jon Martin Aug 09 '11 at 14:56
1 Answers
1
It will capture only the columns you specify, of only the tables you specify, and yes, it will have a before value and an after value in the capture tables. The capture tables do not store the data indefinitely, they are purged after 3 days by default, so you'll need a process, like SSIS, to harvest the data and store it permanently for reporting.
SqlACID
- 4,024
- 20
- 28
-
The time that the data is persisted is configurable. 3 days is by default but you can always increase it. – Ankur-m Jan 10 '13 at 05:09