Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Change Data Capture for a table

Author  Topic  Bex Aged Yak Warrior 580 Posts Posted - 2011-07-12 : 09:41:58 We have a few issues in our application where an erroneous result is being returned (numerous (nolocks) on procs). We need to profile the activity on a table and capture all the data changes. Does Change Data Capture include ALL activity, for example, transactions that are rolled back or just those that are committed? Thanks Hearty head pats