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
1
vote
0 answers

SQL Server 2016 Express and LocalDb connection issues

I'm having a difficult time getting localdb running under IIS in the connection strings. I am running: Windows 10 SQL Server 2016 Express and LocalDb installed I added the following to my applicationHost.config, which I would not like to do if…
chum of chance
  • 6,200
  • 10
  • 46
  • 74
1
vote
2 answers

SQL Server 2016 Express installation error

I have two disks: (VeraCrypt-encrypted) HDD: partition A SSD: partition C Windows 10 Pro. Microsoft SQL Server Express 2016. I have changed from default partition C to A. I am getting this error when trying to install: (For 2014 version It gives…
user3529850
  • 1,632
  • 5
  • 32
  • 51
1
vote
0 answers

Unable to upload SQL database to Azure

Im using SQL server 2016 and SSMS to manage database, im trying to deploy my database to azure through the deploy wizard and end with failure. Pls find below steps: Right click database, select "Deploy database to azure VM" Sign in with azure…
Mike
  • 67
  • 1
  • 11
1
vote
0 answers

Linking a SQL Server table to a text file without SSIS

I want to link a SQL Server table to a text file so that any changes made to the text file, such as creating, deleting, or updating a row, are reflected in the SQL Server table. The best way to do this appears to be SSIS, but I know that this is…
Naiya55
  • 134
  • 1
  • 15
0
votes
0 answers

Group a timestamp column by day and add a column with the first and a column with the last value from that day

I have a timestamp table like this: t_stamp 2023-04-28 20:20:28.497 2023-04-28 20:00:27.940 2023-04-27 19:37:27.413 2023-04-27 16:55:26.817 2023-04-26 15:16:26.273 2023-04-26 12:04:25.753 I tried so far: SELECT distinct…
Luciano Furini
  • 1
  • 2
0
votes
0 answers

Create Hierarchical Tree from 2 Columns in SQL

I am having a large set of data in 2 columns where I need to create hierarchical structure from it. Below is the input table…
Geethu
  • 55
  • 11
0
votes
1 answer

how to solve timeout issue occured while updating the entries in database

A timeout error occurred while registering the record or updating the records in the database. "The timeout period elapsed prior to completion of the operation or the server is not responding." Application throw DbUpdateException error on…
Anjali Vyas
  • 9
  • 1
  • 3
0
votes
2 answers

WHERE string IN string SQL Server

Right now I'm in a trouble and donot know how to solve it. Declare @brand_id varchar(50) ='brand1, brand2' SELECT related_brand_id FROM dbo.Category => result: Row 1: "brand1, brand3, brand5" Row 2: "brand3, brand5" Row 3:…
DannyLee
  • 1
0
votes
1 answer

VS 2019 WebForms VB-project tableadapter not defined?

I am building a web-forms app in VS-2019. I am trying to use code from VS-2017 that worked with the tableadapters in the schema xsd file. I copied the xsd and xss files into the VS-2019 project. I can see all of my tables and queries (vs-2019 and…
John D
  • 517
  • 7
  • 22
0
votes
1 answer

Auditing SQL Server - who is changing what and when? SOX complaince

In my organization, we are doing very limited logging or any sort to capture who is changing what and when. I am seeking help here to understand what should be the best practices to capture any logging whatsoever happening in our SQL Server…
ishan sharma
  • 1
  • 3
0
votes
1 answer

After updating Purchase table I want to automatically update my Stock Table

I am developing Stock Management System. I have to tables like this. tblPurchase Table PurchaseId | ItemCode | ItemName | Quantity | ----------------------------------------------------- 1 | IMT0003 | Dell Laptop | 30 …
user15046818
0
votes
1 answer

How to execute Dynamically created query in sql server

I have written a stored procedure Where I have written a query to get userid. There is a separate database for every userid. So I am trying to run a select query based on this userid obtained from my previous select query in a loop. And I am trying…
Sai sri
  • 515
  • 12
  • 25
0
votes
1 answer

LOOP Through JSON Data and update query in SQL Sever

I have a JSON array as below [ { "CRT_FIRST_NAME": "abc", "CRT_EMAIL": "abc@gmail.com", "CRT_ID": 60 }, { "CRT_FIRST_NAME": "pqr", "CRT_EMAIL": "pqr@gmail.com", "CRT_ID": 61 …
Sai sri
  • 515
  • 12
  • 25
0
votes
2 answers

Query to Convert a specific 12 hour format type to 24 hour format type in sql server 2016

We have a case where the time edited by users is in the format 3/2/20 3:30P (where P denotes P.m.) which I'm trying to convert to the 24hour format to be able to use a join condition with a standard column to something like 2020-03-02…
Zac
  • 3
  • 2
0
votes
0 answers

SqlCommand . ExecuteReader method slow

I have a performance problem with SqlDataReader object. I am used to use Entity Framework but for a specific reason, I should use ADO.NET queries in my app. The problem is, when I execute my query, it takes almost 10 seconds. I run exactly the same…
Coskun Ozogul
  • 2,389
  • 1
  • 20
  • 32
1 2
3
4 5 6 7