Invalid object name OPENJSON

  • BOR15K

    SSCertifiable

    Points: 5767

    I have an Express edition of SQL 2019

    Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19:56:59 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 16299: )

    and I have a new DB with compatibility level set to 150. I use SSMS version 18.5 yet I still cannot execute anything related to JSON, e.g. OpenJSON or ISJSON().

    Can one advise what I am missing, please? I am new to JSON, but need to explore how to process JSON files or strings.

    Thank you all, as usual!

  • Site Owners

    SSC Guru

    Points: 80376

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply