Top "Change-data-capture" questions

Change data capture (CDC) encompasses database design patterns to keep track of changed data and perform actions with it.

How to create Triggers to add the change events into Audit Log tables

Suppose we have 50 tables in a database and we want to capture all the changes (Previous value and new value …

Read More
mysql triggers audit-logging audit-trail change-data-capture
Could not update the metadata that indicates database X is enabled for Change Data Capture. The error returned was 15517

I use SQL Server 2008 and AdventureWorkDB. I want enable Change Data Capture in my database. I execute this command : USE […

Read More
sql sql-server sql-server-2008 change-data-capture
CDC is enabled, but cdc.dbo<table-name>_CT table is not being populated

I have enabled CDC using the following steps: exec sys.sp_cdc_enable_db; exec sys.sp_cdc_enable_table @…

Read More
sql-server cdc change-data-capture
CDC table not working after adding new columns to the source table

Two new columns were added to our source table while CDC was still enabled on the table. I need the …

Read More
sql-server change-data-capture
Is Change Data Capture Performance Loss Restricted to CDC Enabled Tables?

I have read that enabling Change Data Capture obviously has an impact on database performance. Would this performance loss only …

Read More
sql sql-server sql-server-2008 change-data-capture