The other day I had a requirement to identify and delete any objects in the AX 2012 SQL database which are custom made by other means than AX DB synchronize. I am excluding all tables and views which exists in the ModelStore (if you have your model DB separate, you might want to change ModelElement to [YourAXDB_model].[dbo].[ModelElement] to get it...
The post Find SQL tables and views not part of the AOT appeared first on DAXRunBase blog by Vilmos Kintera.
*This post is locked for comments