Jonathan Marshall
SSCrazy
Points: 2633
More actions
July 29, 2015 at 10:37 am
#302815
Hello everyone,
Is there a way to to enable all tables within a specific schema for change data capture or must they be done individually?
Regards,
Jonathan
abhishek_300
Mr or Mrs. 500
Points: 587
July 30, 2015 at 2:03 pm
#1816297
They must be done individually.After a database has been enabled for change data capture, members of the db_owner fixed database role can create a capture instance for individual source tables by using the stored procedure sys.sp_cdc_enable_table
https://msdn.microsoft.com/en-us/library/cc627369.aspx
August 14, 2015 at 5:36 am
#1820005
Thank you much appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply