While Update Database version Error Occurs: 'LAG' is not a recognized build-in function name.

Created by Cheng Kah Poh, Modified on Tue, 15 Sep, 2020 at 8:14 AM by Cheng Kah Poh

Error:


if you see this error message, while updating Database version.


Start from 2019.0.1.2 and 2019.1.1.2

User need to update their existing SQL Server 2008 R2 Express to SQL 2012 Express, to applies 'LAG'

The 'LAG' Function can be used in the following version of SQL Server (Transact-SQL)

SQL Server 2017 ,SQL Server 2016, SQL Server 2014 , SQL Server 2012


Therefore Please Update to at least SQL 2012 Express, to continue Update to QnE version 2019.0.1.2 and 2019.1.1.2.


To Know How to upgrade existing SQL Server 2008 R2 express to SQL Server 2012 Express

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article