When trying to install Microsoft AX 2012 on Windows 2008 R2 running SQL Server 2012 I received a problem installing the Database element
The error in the Windows Application View was as follows:
AXUtil operation failed : Schema
Model store schema creation or update failed.
"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
To resolve a Hotfix was required to be installed and a patch copied to the updates folder where the AX 2012 Installation files are kept. This updates the AXUtil version to 6.0.1108.152
Request and download the Dynamics AX hotfix 2680186 from Microsoft using the link below. You will need a login to the Microsoft Partnersource website