July 28, 2015 at 1:57 pm
When using Change Data Capture on SQL Server 2012 I have researched that you cannot truncate data in a table.
Is this also true if one wanted to delete data from the table?
Getting a little confused about what DDL statements can be ran against a table with CDC enabled.
Does CDC have to be disabled before performing certain DDL statements against a table?
I would like to safeguard the truncation and dropping of certain tables within the dbo schema.
Wondering if I could do this with one fail swoop with CDC enabled on those tables.
The other option would be to use a DDL trigger to prevent certain DDL statements to be performed.
Any further documentation or threads would be greatly appreciated.
Continuing to research the behavior of CDC in the interim.
Thanks in advance.
Regards,
Jonathan
July 30, 2015 at 2:58 am
Best source of information: https://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx
You can delete data from the table, just not truncate it. You can add a column but it doesn't get CDC'd until you create a new capture session.
CDC is a pain in the butt. You're probably going to have to spend a lot of time experimenting with it to know the ins and outs.
August 14, 2015 at 5:37 am
Thank you this is very helpful.
Regards,
Jonathan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply