Skip to Content
0
Former Member
Jul 30, 2006 at 01:50 PM

Where is the record of Change Tracking Table?

33 Views

Hi,I want to track the change of one field in the table.I set the corresponding radio button of "track modifies","track adds" and "track deletes" to "yes" in the Change Tracking Settings pane.(And the backend SQL Server table A2i_CM_Audit_Fields_Info recorded my setting)Then I loaded the repository and started the Data Manager to connect it.In Data Manager,I changed the field value of one record,for example from "" to "test".According to the console guide,for each change, MDM records the date, the time, the user who made the change, the old value, and the new value.

The problem is where I could find the recorded change in system.Does it exist in the back end SQL Server table?If it was true,there are too many table under <repository name>_m000 and <repository name>_z000.I don't know which one it is.

I found one table A2i_CM_History under _z000 which looks like the table the guide mentions,but it was empty.To see the change log,should I do additional setting besides the setting in the Change Tracking Settings pane? Thanks for any advice or gudie.