syntax error ( *EngineEdition != 11) (Microsoft.SqlServer.Management.Sdk.Sfc)

-> I tried checking the properties of a database and saw below error,

TITLE: Microsoft SQL Server Management Studio
syntax error ( *EngineEdition != 11) (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

-> The error basically complains that EngineEdition is not equal to 11 which is SQL Server 2012, but I am on SQL Server 2019.

-> I tried executing below query to check the database properties,

select * from sys.databases where database_id=db_id('JBSDB')

-> The compatibility_level for the database is set to 100 which is SQL Server 2008/ 2008 R2. SQL Server 2019 supports compatibility level starting 100. So not sure why are we seeing this error,

-> I upgraded SSMS to 18.11.1 https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15 and the issue never occurred again.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply