Thursday, January 31, 2013

SQL Server 2012 compatibility error in AX 2012

FastFirstRow and  compatibility error in AX 2012 with SQL Server 2012:

Hi friends its good news to launch SQL Server 2012 but it is compatible only for the AX 2012 R2  for the earlier version it thows compability error as-

Error: can not select a record in application model.The SQL database has issued an error.
"FastFirstRow" is not recognized table hint option. it is intended as a parameter to a table-valued function or to changetable function.ensure that your database compatibility mode is set to 90.

So if you got above error you have to install hotfix KB2680186 launch by microsoft.

Note: Ensure that you have taken full backup before apply hotfix.

Happy DAXing !!!

No comments:

Post a Comment