Can we apply CDC on a view

Hi

I have one query related to SSIS. We have views which may contain more than 1 table. As we are applying CDC on a table, is there any way to apply CDC on View.

Regards

Loganathan

June 18th, 2015 8:41am

No, you can enable CDC only for tables, but not for views; see sys.sp_cdc_enable_table
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 9:02am

Hi Loganathan,

Just as Olaf said, we cannot enable CDC on a view, it must be enabled at the table level, on a table-by-table basis.

The change data capture process retrieves this information from the transaction log and writes it to change tables that are accessed by using a set of functions. A standard view is only a logical abstraction of physical tables and does not provide any actual data storage to change. So we cannot enable CDC on a view.

For more information about Change Data Capture, please see:
http://bradmcgehee.com/2010/04/21/an-introduction-to-sql-server-2008-change-data-capture/

Thanks,
Katherine Xiong

June 18th, 2015 11:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics