SAP Knowledge Base Article - Preview

2020689 - SWPM error: "FASTFIRSTROW" is not a recognized table hints option on MS SQL Server 2012


When installing target system on Windows Server 2012 with MS SQL Server 2012, the following error occurs:

5-22-2014 1-20-54 PM.jpg


In sapinst_dev.log, you can see following trance and errors:

MSSTRC: Checking for fixes: sap_check_if_sick on SQL11 with CVERS == 700.0015

t_MssMessages.remove(WHERE 1=1)

ERROR      2014-05-21 13:44:45.024 [iaxmcsql.cpp:116]
           iastring CIaMssSqlConnect::executeSQL(args_t const& _args)
MDB-05053  Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][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.
[Microsoft][ODBC SQL Server Driver][SQL Server]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. 



SAP systems on Windows Server 2012/MS SQL Server 2012


SAP NetWeaver all versions


KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.