4.10 Build from source results in errors

Hello all

Ok trying to update to 4.10 and as usual set build to release, cleaned and rebuilt solution then this..

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
   at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.<>c.<UseNopExceptionHandler>b__1_1(HttpContext context) in C:\Users\Jonathon.JON-HOPLEY-NET\Documents\UPGRADE\4.10\Presentation\Nop.Web.Framework\Infrastructure\Extensions\ApplicationBuilderExtensions.cs:line 83
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
ClientConnectionId:9fcbaf11-5596-424d-a185-83afff015f0b
Error Number:102,State:1,Class:15

If I omit the home page news, bestsellers and poll the Index page will load, however I get the same error on category pages.

Which version of Sql server are you using?

SQL Server 2014 Management Studio

Jon.Hopley.Net wrote:

SQL Server Management studio is only client. you need to check your MS Sql server version.

About the OFFSET, this keyword was added in SQL Server 2012.

for more info.

https://stackoverflow.com/questions/42263984/incorrect-syntax-near-offset-command

In SSMS, you can execute this query to see the version of SQL Server

select @@version

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64)
  Mar 26 2015 21:18:04
  Copyright (c) Microsoft Corporation
  Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

Jon.Hopley.Net wrote:

Successful SQL Server Update

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
  Feb 10 2012 19:39:15
  Copyright (c) Microsoft Corporation
  Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )


Thanks