Top "Sql-server-2016" questions

Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.

SQL Server OPENJSON read nested json

I have some json that I would like to parse in SQL Server 2016. There is a hierarchy structure of Projects-&…

json parsing hierarchy sql-server-2016 open-json
JSON text is not properly formatted. Unexpected character 'N' is found at position 0

I am new to JSON in SQL. I am getting the error "JSON text is not properly formatted. Unexpected character …

json sql-server-2016 sql-server-json
Accessing JSON Array in SQL Server 2016 using JSON_VALUE

I am stuck while accessing array inside json using newly introduced JSON_VALUE function. Please consider following code - IF …

sql sql-server json sql-server-2016
Please create a master key in the database or open the master key in the session before performing this operation

I get the following error on secondary replicas when trying to restore an encrypted backup even though the replica has …

sql encryption certificate sql-server-2016 private-key
SSIS Error: VS_NEEDSNEWMETADATA

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting …

sql sql-server tsql ssis sql-server-2016
OPENJSON does not work in SQL Server?

I want to use JSON functions in SQL Server 2016, but when I try to execute OPENJSON function, I get the …

sql-server json sql-server-2016
The report server was unable to validate the integrity of encrypted data

The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) . Could not restore the …

sql-server encryption reporting-services sql-server-2016
SQL to JSON - array of objects to array of values in SQL 2016

SQL 2016 has a new feature which converts data on SQL server to JSON. I am having difficulty in combining array …

sql json sql-server-2016
Passing JSON type as parameter to SQL Server 2016 stored procedure using ADO.Net in ASP.Net Core project

Can someone give example how to pass JSON type as parameter to SQL Server 2016 stored procedure using ADO.Net in …

c# asp.net json sql-server-2016
System.OutOfMemoryException occurs frequently after Upgrading SQL Server 2016 to version 13.0.15700.28

I am running Windows 10 Pro 64 bit on a dev box that has multiple monitors, 16 gigs DDR4 RAM, 4 Ghz I7, GTX 970. …

sql-server ssms sql-server-2016 ssms-2016