Stack Overflow
Stack Overflow

Questions tagged [sql-server-2016-express]

Use this tag for questions specific to the Express version of the 2016 version of Microsoft SQL Server. The Express version is an entry level, free version of SQL Server 2016 with license restrictions such as the maximum size of a database and the number of concurrent users.

Microsoft SQL Server Express 2016 is the free, Express version of SQL Server 2016. The Express version has support for many of the capabilities of SQL Server 2016 making it a reasonable choice for applications that need a database engine that has similar characteristics as SQL Server 2016 yet do not need the full feature set and operating capacity as the full SQL Server 2016.

Limitations of SQL Server Express 2016 include database size, limit of 10 GB for each database though multiple databases are allowed each with the 10GB limit, and hardware capabilities that the software will use such as memory, max of 1GB, and number of processor cores, max of 4. There are also some additional reliability and robustness provisions in the standard SQL Server 2016 such as fallover and other advanced provisions that are not part of SQL Server Express.

SQL Server Express 2016 has two types of deployment. The first is similar to SQL Server 2016 in which it is installed as an out-of-process database engine running as a Windows service. The second is an an embedded database engine, Server Express LocalDB, which runs as an in-process database engine within the application using it rather than as a Windows service.

94 questions
105
votes
14 answers

Can't connect to localhost on SQL Server Express 2012 / 2016

I just downloaded the latest version of SQL Express 2012 but I cannot connect to localhost. I tried localhost\SQLExpress and Windows authentication but it gives me an error message saying cannot connect. Am I missing something here? I've used SQL…
dido
  • 3,053
  • 10
  • 30
  • 41
98
votes
4 answers

SQL Server® 2016, 2017 and 2019 Express full download

All previous version of SQL Server Express were available in both web and full downloads. But I cannot find full download of SQL Server® 2016 Express. Does it exist? Asked the same question on MSDN forums, not much luck:…
Alex I
  • 1,514
  • 1
  • 13
  • 17
32
votes
1 answer

SQL Server Express vs express localdb

I am having quite a few problems understanding differences between regular SQL Server Express and express Localdb. Before you go ahead and tag a previous post about this question, I've went through question history quite a few times. The resources…
Dan J
  • 323
  • 1
  • 3
  • 5
12
votes
3 answers

TSQL Rounding VS C# Rounding

This problem has driven me crazy. I am using Microsoft SQLExpress 2016 to write a stored procedure. One of the requirement is to do rounding. But every now and then, the rounding is wrong. I found out that T-SQL rounding is not exactly the same with…
Sam
  • 1,529
  • 18
  • 48
12
votes
1 answer

A valid destination folder for the install could not be determined when installing SQL Server Management Studio 2016

Whilst installing SSMS 2016, I get the following error and setup terminates: SQL Server 2016 Common Files: A valid destination folder for the install could not be determined. I've tried the following solutions: Delete all files in %TEMP%…
Ivan-Mark Debono
  • 12,439
  • 21
  • 93
  • 195
5
votes
2 answers

SQL Server 2016 express install error: attempted to perform an unauthorized operation

Never thought it would be this bad when trying to install SQL Server 2016 Express Edition on Windows 10. I had both SQL Server 2014 and SQL Server 2012 installed and was mainly using SQL Server 2014. Then I thought I should upgrade and tried to…
stt106
  • 2,682
  • 26
  • 42
4
votes
1 answer

SQL Server: Why is SELECT on case insensitive column faster than on case sensitive?

I use SQL Server 2016 Express and a Java application with JDBC driver version 4.2. My database has a collation of Latin1_General_CI_AS (case insensitive). My table has a column of type VARCHAR(128) NOT NULL. There is an unique index on that…
zuserus
  • 206
  • 2
  • 5
3
votes
2 answers

SQL Server : average sales with Date Range Criteria

I am brand new to SQL Server (like 10 mins). I have a test database that contains a few columns (Units, Date, Master ID, AVE Monthly Sales). The Average Monthly sales is empty. Background: I import data from Excel files, the files are built from…
Mark Blackburn
  • 95
  • 6
3
votes
2 answers

Cannot create database with Code-First

I am using Visual Studio 2015, Entity Framework v6, and SQL Server 2016 Express. In the past I created a database using a SqlConnection and SqlCommand and stuff the SQL into a string. Now, I am teaching myself EF6 on Entity Framework Tutorial. On…
KMC
  • 18,443
  • 53
  • 146
  • 238
2
votes
3 answers

SQL update multiple rows based on value in one of the rows

I have a process that is running daily on a datafeed and updating the last_update_time (a datetime field) on all items in our inventory database that are present in the datafeed. The problem I am having is when an item is removed from the datafeed…
Jason
  • 21
  • 1
2
votes
0 answers

How do I set which version of SQL Server Visual Studio will try to use?

A "friend" sent me an asp.net project. I've opened it in Visual Studio 2017. Everything seems fine, except that when I run it I get an error when it tries to use the internal database. The offending line is: GridBindingData data =…
GreySage
  • 995
  • 17
  • 38
2
votes
1 answer

Access multiple instances in SQL Server

There are two instances of SQL Server installed on my PC. Version 11 and 13. for accessing version 11, I enter .\ in a server name for accessing version 13, I enter (LocalDB)\MSSQLLocalDB When it comes to IP address I enter 192.168.1.104 (my IP)…
abhi
  • 47
  • 1
  • 9
2
votes
1 answer

SqlCommand.ExecuteNonQuery() always returns 0

I'm trying to process an UPDATE statement via my c# code. I use the following... using (SqlCommand cmd = new SqlCommand(query, sqlConn)) { cmd.Parameters.AddWithValue("@CUSTOMER", intCustomer); cmd.Parameters.AddWithValue("@CONDITION",…
Arvo Bowen
  • 3,742
  • 6
  • 37
  • 78
2
votes
2 answers

ASP.NET Core: An attempt to attach an auto-named database for file failed

I know this question has been asked many times, but I'm still unable to find a question similar to my scenario. I'm working on an ASP.NET Core WebAPI project. It all worked well and I can't really reproduce what if at all I did to screw this…
Shimmy Weitzhandler
  • 92,920
  • 119
  • 388
  • 596
2
votes
2 answers

MsSql server:running stored procedure

I have a table CREATE TABLE [dbo].[DealerInfo]( [DealerName] [nvarchar](100) NULL, [Address] [nvarchar](100) NULL, [City] [nvarchar](100) NULL, [County] [nvarchar](100) NULL, [Fax] [nvarchar](50) NULL, [CompanyWebSite]…
Michael27
  • 161
  • 1
  • 13
1
2 3 4 5 6 7