Post reply

Invalid object name OPENJSON

  • June 4, 2020 at 8:30 am

    #3760336

    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!

  • June 5, 2020 at 9:10 am

    #3760750

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

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

  • September 13, 2020 at 12:33 pm

    #3788133

    Sounds strange. Are you running queries from SSMS?

    Can you do a screenshot of following from your system:

    select compatibility_level, @@VERSION, *
    from sys.databases
    where name = DB_NAME()
    go
    select *
    from openjson ('{"test" : 1}')

  • September 14, 2020 at 4:43 pm

    #3788372

    You should see something like this. My 2019 Express container (comment is the @@version data) shows JSON works

    2020-09-14 10_43_05-SQLQuery2.sql - .,51433.master (sa (51))_ - Microsoft SQL Server Management Stud

Viewing 4 posts - 1 through 3 (of 3 total)

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