I was looking to export the AX tables
SecurityRole
SecurityRoleTaskGrant
SecurityTask
Into a file. i have no intention of reimporting them. Just wanted to learn the patterns. When I attempted to do this with the Export function in AX, the function “worked” but no data were returned to the destination file. I learned reading
technet.microsoft.com/…/aa834324.aspx
That these tables are “blocked” and cannot be exported. I certainly could guess why this might be – AX doesn’t want one to attempt to re-import them into another instance and corrupt it – but how would someone get this information for the purpose I described some other way? Is there some “magic SQL” statement I can run in the database? The simplest answer would be the best one.