Table & Field Numbers – SQLDICTIONARY
Ever wondered how to lookup a table ID using a SQL statement or how tableid2str works? The hidden table SQLDICTIONARY has the field and table numbers from the shown in the AOT. It also includes the size and type of the columns.For the anal retentive you can update data in this table to [...]
Copying AX Environments
After making so many environment copies I like to think I have it down to a science. I have a program which runs SQL scripts from a directory. Here are a few things that I do:Disable all usersClear the user login historyClear the pending outgoing emailsRemove all alertsDelete batchesChange paths [...]
User is not authorized to insert a record in table SYSSETUPLOG
While doing a routine upgrade of a third-party add-on for Dynamics AX 4.0 I got the following error:User '____' is not authorized to insert a record in table 'SYSSETUPLOG'. Request denied.The SysSetupLog table, labeled "Installation information," stores application and kernel version information as well as the status of the System [...]