Stack Overflow
Stack Overflow

Questions tagged [sql-server-2016]

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

Microsoft SQL Server 2016 v.13.0.1601.5 Ready To Manufacture (RTM), was released on June 1, 2016.

There are many editions of SQL Server 2016:

1- Entreprise Edition : Comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution with mobile BI built in, in-database advanced analytics at scale, and unlimited virtualization with software assurance. Enterprise edition provides the highest scale and performance for Tier-1 workloads.

2- Standard: Find rich programming capabilities, security innovations, and fast performance for applications and data marts. Easily upgra

3- Developer: Build, test, and demonstrate applications in a non-production environment with this free, full-featured set of SQL Server 2016 SP1 Enterprise edition software.

4- Express: Deploy small databases in production environments with this free, entry-level database that’s ideal for building small, data-driven applications up to 10 GB of disk size.

5- Compact: Free, embedded database app for building ASP.NET websites and Windows desktop applications.

6- Web: Secured, cost effective, and highly scalable data platform for public web sites—available to third-party hosting service providers only.

References

3794 questions
19
votes
9 answers

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, I deleted my .mdf file. Since then, executing Update-Database (to apply my migration) throws the…
Stephen Paul
  • 37,253
  • 15
  • 92
  • 74
18
votes
5 answers

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 the master key (dmk), service master key, certificates and private keys restored from the originating/primary server that…
Hiram
  • 409
  • 1
  • 4
  • 13
18
votes
5 answers

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 encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting…
sqllearner
  • 371
  • 1
  • 3
  • 11
17
votes
3 answers

Edit a dtsx through SSMS

I created and executed a dtsx with SSMS corresponding wizard: This was to import a flat file in an existing table. At the end I saved the "package" as a .dtsx file Now I need to modify the column mappings and re-execute this package. Is there any…
cnom
  • 3,071
  • 4
  • 30
  • 60
17
votes
5 answers

Conditional UNION ALL in table function

So use case is as follows - there're some parameter, based on which I want to select data from one table or another. create table dbo.TEST1 (id int primary key, name nvarchar(128)) create table dbo.TEST2 (id int primary key, name nvarchar(128)) So…
Roman Pekar
  • 107,110
  • 28
  • 195
  • 197
16
votes
2 answers

Incorrect syntax near format in BULK INSERT?

I'm trying to figure out why the BULK INSERT command I'm using isn't recognizing the FORMAT and FIELDQUOTE options used in the command. BULK INSERT dbo.tblM2016_RAW_Current_Import_File FROM '\\x\tms\SCADA.dat' WITH ( FIRSTROW = 1, FORMAT =…
Jake
  • 341
  • 1
  • 3
  • 12
16
votes
4 answers

SQL Server Always Encrypted with .NET Core not compatible

I'm trying to use the Always Encrypted feature of SQL Server 2016 with .NET Core and seems like it can not be used (yet). Trying to import the Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider from Nuget, I get an error stating…
Los Morales
  • 2,061
  • 7
  • 26
  • 42
16
votes
3 answers

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. I run SQL Management Studio with SQL Server 2016 Developer Edition along with VS 2015 Enterprise Update 3. Yesterday I upgraded Sql…
djangojazz
  • 14,131
  • 10
  • 56
  • 94
16
votes
3 answers

Why can I not install SQL Server Express 2016 on Windows 7 Professional 64 bit SP1?

When trying to install SQL Server 2016 Express in Windows 7 Professional x64 SP1 in VMware I get the following message. What can I do to solve this?
Hamza Ahmed
  • 1,571
  • 4
  • 18
  • 35
16
votes
3 answers

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 Server Reporting Service Product Samples. It appears that the latest supported version on the samples page (with regards to…
Jason Richmeier
  • 1,595
  • 3
  • 19
  • 38
14
votes
5 answers

Cannot be opened because it is version 852. this server supports version 782 and earlier

I am using Visual Studio 2017 and SQL Server 2014. While attaching a database file to Visual Studio, I get this error: "" After upgrading the file I used this connection string
Bilal Ahmed
  • 185
  • 1
  • 3
  • 12
14
votes
3 answers

SQL Server 2016 for JSON output integer array

I'd like to get JSON with an array of integers using SQL Server 2016's For JSON feature. I'm stumped on array of integers. Database table structures: declare @Employees table (ID int, Name nvarchar(50)) insert into @Employees values (1, 'Bob'), (2,…
Jens Frandsen
  • 832
  • 9
  • 13
13
votes
3 answers

SQL over clause - dividing partition into numbered sub-partitions

I have a challenge, that I've come across at multiple occasions but never been able to find an efficient solution to. Imagine I have a large table with data regarding e.g. bank accounts and their possible revolving moves from debit to…
Stanley Gade
  • 133
  • 6
13
votes
2 answers

How can I keep SSMS Find and replace in files "Look In" from changing

In SSMS when I do a Find and Replace in Files (default keystroke CTRL+SHIFT+H) Edit > Find and Replace > Replace in Files If I set the "Look In" to "Current Document" then do a change and select the Replace All button, the Look In dropdown…
Mark Schultheiss
  • 32,614
  • 12
  • 69
  • 100
13
votes
4 answers

SQL Server 2016 - Temporal Table - how to identify the user

Is it possible to get the information about the user/connection that modified data that is in the historical table? I read about the audit scenario where I can use temporal tables and that it's possible to detect who has changed the data. But how…
user1481065
  • 487
  • 1
  • 4
  • 16
1 2
3
…
99 100