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 using System copy option of SWPM Tool (SAP Note 1680045) inc. WIN OS -and DB-Upgarde, the following error occurs:

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 1
Support Release 1 > Software Life-Cycle Options > System Copy > MS SQL Server > Taret
System Installation > Central System > Based on AS ABAP > Central System(Last error reported
by the step: 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][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.

Solution: If this message is displayed as a warning, you can ignore it. If this is an error, contact
SAP support.
). You can now:
      - Choose Retry to repeat the current step.
      - Choose Log Files to get more information about the error.
      - Stop the option and continue with it later.

Log files are written to <Drive>:\Program
<Directory>

• In sapinst_dev.log, the following trace and error can be seen:

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

TRACE      
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. 

Read more...

• All SAP systems based on SAP NetWeaver 7.0# and higher, which are supported on Windows Server 2012/MS SQL Server 2012 according the "Product Availability Matrix" (PAM)
• Software Provisioning Manager (SWPM)

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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