Enabling ModifiedDatetime Column in all table automatically


I am very new to Dynamics AX so please excuse if this is simple question, We have customise AX to fit that into our business model, now working on datawarehousing to pull data out of SQL 2008 Dynamics AX database into another SQL 2008 Server using SSIS for this we’ll be using ModifiedDatetime on the required table for incremental update.

We noticed that in most of the table ModifiedDatetime column is not enable in AOT, is there easy way to enable these on all table programmatically or run any script?

Thanks you help is much appreciated.



Thanks Harish, this helps, I’ll try this in Test environment.