Error Message:
Error text: [Microsoft][SQL Server Native Client 10.0][SQL Server]”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.SQL error code: 321
Call stack:
(C)ClassesApplicationVersionfpkSlnIsvApplAll – line 20
(C)FormsSysAboutMethodsRun
OR
“Cannot select a record in Application Model (UtilElements). The SQL database has issued an error. SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]”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.”
SQL statement: SELECT T1.NAME,T1.RECORDTYPE,T1.PARENTID,T1.UTILLEVEL,101090 FROM UTILELEMENTS T1 WHERE ((RECORDTYPE=?)
AND (NAME=?)) OPTION(FAST 20)
Solution:
Microsoft Dynamics AX 2012 Management Shell –
Axutil schema
Reference
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2709934#releasenote