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.

92 questions
0
votes
1 answer

When installing an MSI, CREATE DATABASE permission denied

I have created an MSI file that installs a program. As part of the installation process, I need to create a local database using SQL Server 2016 Express on Windows 10 Enterprise. When I run the MSI, the following error occurs: CREATE DATABASE…
Ben
  • 31
  • 7
0
votes
2 answers

SQL Multiple Conditions in max statement not working

I am attempting to filter my table and get the item that sold for the most amount of money. In order to do this I am using "AuctionOpen" to determine whether or not the auction is still open. The auction cannot be open and have the item been sold…
SavageCoder
  • 81
  • 1
  • 11
0
votes
1 answer

Trouble after Upgrade SQL Server version and have two server now in services.msc

I'm a beginner in this, I've been searching for long on internet. But as many solution in internet, I don't understand as much i wanted. And I have some question to for resolution. I see a place the recommend to ask some like this as Super User, but…
FenrirOnTheNet
  • 13
  • 5
0
votes
0 answers

MSSQL use in PHP

I am using the following PHP code to fetch data from my mssql table: $query2 = "select kArtikel, cArtNr, fVKNetto, fUVP from tartikel"; $result = mssql_query($query2); $a= array(); while ($row = mssql_fetch_assoc($result)) { $a['data'][] =…
thowi
  • 35
  • 7
0
votes
0 answers

Microsoft Sync Framework 2.1: "Last Write Wins"

I would like some help finding any (C#) example of Sync Framework 2.1 using the "Last Write Wins" conflict resolution style. I followed the example MS put out, and my provisioning/sync works just fine, my issue is that I cannot use…
Developing DEV
  • 11
  • 5
0
votes
0 answers

Getting error while connecting VS2013 with SQL Server 2016

I'm getting the below error while trying to connect and get the data to Visual webpart (VS 2013) from SQL Server 2016: An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code…
karthik
  • 101
  • 3
0
votes
1 answer

Change credentials for Data Source

I am following the tutorials for reporting services on the microsoft website and currently on: this tutorial. I am just going to the web portal on my local host, going to the data source option of the report, but it is impossible to change something…
StefanE
  • 103
  • 8
0
votes
0 answers

How does one structure queries to amalgamate master detail records over a given period

Consider the following scenario (if it helps think Northwind Orders / OrderDetails). I have two tables LandingHeaders and LandingDetails, that record details about commercial fishing trips. Typically, over the course of a week, a fishing vessel can…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
0
votes
1 answer

Sql Server Language Settings - Preserve UK Date setting in view

I am trying to convert string date/times from existing data to T-SQL DATETIME type. The strings are in UK format 'dd/MM/yyyy HH:mm:ss' CREATE VIEW v_DateFix AS SELECT CAST([Start Date Local] AS DATETIME) AS StartDate FROM MyTable GO This…
TomFp
  • 469
  • 1
  • 5
  • 13
0
votes
0 answers

Created database doesn't have compatibility level 130 in SQL Server 2016

I installed SQL Server 2016 for individual user version. After that, I created a database but when I check the compatibility level of that database, it says 90. When I was trying to change compatibility level of database it says Valid values of…
Rajkumar Dorkhande
  • 64
  • 6
0
votes
1 answer

SQL Server Database Mail Error/Missing

Current SQL Server: SQL Server 2016 Express SP1 Microsoft SQL Server 2016 (SP1-CU7-GDR) (KB4057119) - 13.0.4466.4 (X64) Dec 22 2017 11:25:00 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 (Build…
Leigh
  • 11
  • 3
0
votes
2 answers

SUM of 2 aliases in SQL Server

The Balance column shows current Stock on Hand + Open PO minus QTY Entered. I have an existing query with ALIASes in the SELECT statement: SELECT dbo.Items.ItemNo, dbo.Items.Name, dbo.Vendors.Name AS VendorName, …
user9399808
0
votes
1 answer

Unable to change Authentication Mode in SQL Server: Microsoft SQL Server, Error: 229

I have just installed SQL Server 2016 Service Pack 1 Express and SSMS 2017 using the Basic option from the installation wizard. After installation, I wanted to change the mode of authentication from Windows Authentication to SQL Server…
user9335731
0
votes
1 answer

Upgrade Application to use SQL Server 2016 from SQL Server 2008

I have a 32-bit application that was developed using SQL Server 2008 Express SP2, since we are moving to Windows 10 we are going to be using SQL Server 2016 Express and I get these errors when I start the application: Message:Could not load file or…
vee
  • 389
  • 5
  • 19
0
votes
1 answer

Two Split String Merging into one table variable

I have two string variable having value like @id = '1#2#3#4#5' @fid = '11#12#13#14#15' in stored procedure i used table varrible with split string to make the table for both of the varrible Select Value from STRING_SPLIT(@id,'#') Select Value from…
Kshitij
  • 37
  • 1
  • 9
1 2 3
4
5 6 7