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
3 answers

How to sort the words of a single cell in an SQL table?

For example: Pillars 101 in an apartment Zuzu Durga International Hotel Wyndham Garden Fresh Meadows Need to sort the above as, 101 an apartment in Pillars Durga Hotel International Zuzu Fresh Garden Meadows Wyndham
Abynez
  • 3
  • 1
  • 4
0
votes
1 answer

Cannot update SQL Server table from powershell

I have created a test database in SQL Server 2016 Express, it holds 1 table labeled drivers. I use PowerShell to perform ciminstance query of installed drivers, then insert those values into the test database driver table. (the insert works as…
grunzer
  • 1
  • 1
0
votes
1 answer

SQL Server running out of space on large drive

I've got a VB.Net program that updates an SQL Server 2008R2 database. The disk is using 86.2Gb of 126Gb so there's lots of free space. The autogrowth is set, as you can see, but I get the following error message on various threads: Could not…
Tym
  • 89
  • 2
  • 14
0
votes
1 answer

VB6 and Sql server 2016 Express connection string

In one of our old vb6 app connection string is as follows: nk = "Provider=SQLOLEDB;" nk = nk + "Integrated Security=SSPI;" nk = nk + "Persist Security Info=False;" nk = nk + "User ID=sa;" nk = nk + "Password=******;" nk = nk + "Initial Catalog=" &…
mursel.musabasic
  • 34
  • 1
  • 4
0
votes
1 answer

Does parameterized query remove reserved keyword and symbols

If so, if my varchar contains ; or [ or the keyward "Create" that will get automatically deleted? I don't think that was this simple, what is the mechanism of parameterization to avoid sql injection?
KMC
  • 19,548
  • 58
  • 164
  • 253
0
votes
1 answer

sql server 2016 basic select issue

I have basic database table with some rows. see the queries below. first query selects a record from the database.. you see the result. that result is not the same as the other two result. yet I am retrieving the same record from the table using…
Etienne
  • 179
  • 3
  • 12
0
votes
1 answer

SQL Server encryptbycert capping off

My problem is that I'm trying to encrypt a column in a SQL Server database because of policies of my work place. I have access only to simple methods for encrypting (TDE seems out of my possibilities) so I've tried using EncryptByCert or…
José Alejandro Castelán Ibarra
  • 13
  • 7
0
votes
1 answer

Backwards Compatibility from SSIS Packages

We have two SQL Servers, one is our testing Server and the other our live Server. We want upgrade the live Server to SQL Server 2016. We have SQL Server 2012 on both servers at the moment. So my questions is: Is it possible to have as Data Source…
Minick
  • 1
  • 1
0
votes
1 answer

MSSQL 2012 Enterprise with json functionality from MSSQL 2016

I have server with MS SQL Server 2012 Enterprise Edition, but I would like to use new functionality from MSSQL 2016. If I had express edition that issue would be easy - I could free upgrade my SQL Server to 2016 Express Edition. Is it possible to…
steryd
  • 363
  • 3
  • 9
0
votes
1 answer

Unable to connect to Sql server 2016 express

I have two sql server installed in my machine. The 2016 one shows SQL Server(MSSQLSERVER) name and 2014 one SQLEXPRESS respectively. When I log in from sql server management studio using this hostname\SQLEXPRESS I get loggged into 2014 instance but…
pankaj
  • 1,030
  • 5
  • 19
  • 41
0
votes
1 answer

Visual Basic 2015: Populating a ListView from SQL Connection

I started learning Visual Basic at the request of my employer, and I've reached a point in my learning project that is frustrating me. I'm attempting to populate a ListView using data from a specific table in my SQL database, but I keep getting the…
Kirloth
  • 3
  • 2
0
votes
1 answer

SQL UPDATE syntax to auto rearrange number

I have a very quick question. I have a series of orders where each order can have a priority. The priority can be either NULL or INT. Every now and then I want to arrange the priority back starting from 1. For example: NULL, NULL, 5, NULL, 7, NULL,…
Sam
  • 1,826
  • 26
  • 58
0
votes
1 answer

SQL Server 2016 list instances

I am using the code below in my windows application to get local servers, when I was using SQL Server 2012 it was working without any errors, but when I downloaded SQL Server 2016, I got the exception : Exception: An exception occurred in SMO…
T.Hajjar
  • 77
  • 1
  • 5
0
votes
3 answers

Visual Studio Unable to Add Data Connection to SQL Server Express 2016

I'm working in VisualStudio Community 2015, SQL SERVER EXPRESS 2016 and when I try to add server connection with sqlServer appears the error I attach below: (After TEST the connection and be safe that all is right)
Sergio M.
  • 88
  • 1
  • 7
0
votes
1 answer

using SQL Server 2016 inside vs2015 is this normal?

I'm trying to learn asp.net, and suddenly in the free online course SQL was used. I found SQL Server 2016 to be free for developers and so I installed it. Eventually i managed to create manually a simple database, and put some values in it, well not…
Peter
  • 2,043
  • 1
  • 21
  • 45
1 2 3 4
5
6 7