Invalid object name OPENJSON
-
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!
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
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}') -
You should see something like this. My 2019 Express container (comment is the @@version data) shows JSON works
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply