AX 2012 Installation SQL related error

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)\Classes\ApplicationVersion\fpkSlnIsvApplAll – line 20

(C)\Forms\SysAbout\Methods\Run

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

Advertisements

One thought on “AX 2012 Installation SQL related error

  1. Pingback: Remember to upgrade the modelstore schema - Yet Another Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s