Change Data Capture in SQL Server 2008. Analysis. Oct 16, 2008 3 mins. ... If you need to know the column data involved in an insert, update or delete statement then CDC is for you.

For example, in Oracle you can alter a character column to a larger size, but not to a smaller size. Additionally, it may be possible to change a column from one numeric data type to another. DB2 ...