Top "Sql-server-2016" questions

Database '[DatabaseName]' already exists. Choose a different database name

I'm following this guide illustrating a code-first approach with Entity Framework core. Migrations were functioning correctly until, at some point, …

asp.net-core entity-framework-core sql-server-2016

String_agg in sql server 2016

Here is my code in sql server 2016 insert into @entdef_queries(entitydefid,squery) select A.entitydefid , ( select String_agg(cols,…

sql sql-server sql-server-2016 string-aggregation

How do you OPENJSON on Arrays of Arrays

I have a JSON structure where there are Sections, consisting of multiple Renders, which consist of multiple Fields. How do …

json tsql sql-server-2016

SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine …

sql-server ssis sql-server-2016 sql-agent-job ssis-2016

Custom Authentication (Security Extension) with SSRS 2016

I am trying to implement custom forms authentication with SSRS 2016. Within this article, a reference is made to the SQL …

sql-server reporting-services sql-server-2016 ssrs-2016

The best mechanism for alter columns of system versioning tables (Temporal Table)?

I have a system-versioning table with history table related as follows: CREATE TABLE [dbo].[ExpenseCenter_Archive]( [ExpenseCenterId] [tinyint] NOT NULL, […

sql-server sql-server-2016 temporal

Deploying SSIS Package - 'Failed to load Assembly Microsoft.SqlServer.Management.IntegrationServicesEnum'

I have a fresh install of SQL Server 2016 Developer with SSIS, on a clean install of Windows 10 When I try …

sql-server ssis sql-server-2016

SQL Server JSON_Modify, How to Update all?

i am trying update all columns with a value with Json_Modify: DECLARE @JSON NVARCHAR(MAX) SET @JSON = N'{ "A":1, "…

sql-server json sql-server-2016 sql-server-json

Database name 'tempdb' ignored, referencing object in tempdb

Instead of checking temporary table existence like this: IF OBJECT_ID('tempdb..#table') IS NOT NULL BEGIN; DROP TABLE #table; …

sql sql-server tsql sql-server-2016

Entity Framework not working with temporal table

I'm using database first entity framework 6. After changing some of the tables in my schema to be temporal tables, I …

c# sql-server entity-framework-6 sql-server-2016 temporal-database