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.
| Author |
Topic |
|
vivek.chopra.in
Starting Member
1 Post |
 Posted - 2014-04-21 : 16:13:59
|
| Hi,I am using SQL Server 2012 and to me a part of data captured by CDC is not making sense.I have a table called 'Schema.Table1', and I enabled CDC on it by running 'sys.sp_cdc_enable_table'. I see that a table called 'cdc.Schema_Table1_CT' got created which now gets an entry when ever I Insert, Update or delete a record in the original table.Till this point every thing works fine. My original Table has a NOT NULL INT column called 'AuditTrackerUserID' with a default value of 1996. My application does not provides a value for this column, but because the column itself has a default value, records get inserted without error.When I try to execute the following Query I see multiple records with __$operation of 3 and 1.SELECT * from cdc.Schema_Table1_CT where AuditTrackerUserID IS NULL My expectation is that I should not ever see any record returned by this query because AuditTrackerUserID is a not null column, but I do.Can anyone please explain this behavior>-Vivek. |
|
|
|
|
|
CDC (change Data Capture) not capturing data