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

Unable to connect to Management Studio an "error occured while connecting to the SQL Server"

I'm familiar with basic SQL through work but I'm trying to improve. All I want to do is create my own local database on my laptop to play around with and follow online tutorials. I've been trying all night to login to Microsoft SQL Server Management…
jm0987
  • 1
  • 3
0
votes
2 answers

ETL from SQL Server 2016 to SQL Server Management Studio 2005

I am trying to copy a database from sql server 2016 server to another server in sql server managment studio 2005. (server1.database1) to (server2.database1) I tried detach and attached method and it did not work. I also tried to copy the data base…
Pedram Salamati
  • 137
  • 10
0
votes
1 answer

Jsondata returning in chunks and with / appended

How to get data in one go without / in data? [ [ { "JSON_F52E2B61-18A1-11d1-B105-00805F49916B": "[{\"OffersCount\":4,\"Id\":1,\"Name\":\"@M The World Cuisine Restaurant…
Vaibhav Ramteke
  • 183
  • 1
  • 1
  • 6
0
votes
0 answers

Is there some reason for updating to SQL Server 2016 Express for ordinary simple scenarios?

I have noticed that Microsoft recently released SQL Server 2016. There a lot of new features involving clouds, security, encryption, But I can hardly find something useful for me. I don't use cloud, I don't use failover, I don't use encryption. I…
Tomas Kubes
  • 23,880
  • 18
  • 111
  • 148
0
votes
0 answers

Unable to connect Visual Studio to correct server after fresh SQL Server Express install

I had a bunch of old/conflicting named instances of SQL Server on my machine, so I deleted them and decided to create a fresh default instance of SQL Server 2016 Express. Which created myriad problems... First, I tried running my migrations in my…
Jenergy
  • 11
  • 3
0
votes
0 answers

Unable to Configure SQL-SEVER 2016 with JDBC

I am recently trying to configure MS SQLServer with JDBC driver , I have installed SQL SERVER EXPRESS edition 2016 and JDBC DRIVER 4(sqljdbc 4.0).After modifying and running sample code from net for my own test purpose I have got this…
Kalyan
  • 1,880
  • 11
  • 35
  • 62
0
votes
2 answers

Not seeing "Execute stored Procedure" in SQL Server 2016

Is anybody else having an issue when they right click on an SP, and not seeing the option to execute the SP? Only option that I have is to script as execute. I am running SQL Server 2016 express.
Albert Vincent
  • 51
  • 9
0
votes
1 answer

How to Install Reporting Services from SQL Server 2016 Express

Trying to test SQL Server 2016 Express and Reporting Services. But I can't select Reporting Services as a feature as described in this post: https://dba.stackexchange.com/questions/ask It quotes the Microsoft homepage:…
SQuirreL
  • 129
  • 1
  • 13
-1
votes
1 answer

Looping array Cursor not looping more than once - SQL SERVER

I have an array which I stringified in Javascript as below [{PlanID:1},{PlanID:2},{PlanID:3}] I am executing the SP as below exec save_plan [{PlanID:1},{PlanID:2},{PlanID:3}] I am trying to save each plan ID as each row in table plan, for which I…
Sai sri
  • 515
  • 12
  • 25
-1
votes
1 answer

Access Array record and normal record from JSON

I am new to handling json records. I have a json record as follows: {"responseobj":{"ResponseCode":"0","ResponseDesc":"Success"}, …
Shahul
  • 99
  • 3
  • 8
-2
votes
2 answers

SELECT values to create a unique row with optional foreign key

I have several tables in a SQL Server database, two of them (Table1 and Table2) I would like to select a specific subset from, to fill in a third table (Table3). In Table1 there are 25 columns, from which I am only interested in three, let's call…
Eric
  • 1,321
  • 2
  • 15
  • 30
-2
votes
1 answer

How to LOOP a query that is created dynamically in SQL Server

I have a stored procedure where I am getting the database name from a table and then trying to create a dynamic query from this database name and fetching the results. Once the results are fetched I need to loop these results for further queries to…
Sai sri
  • 515
  • 12
  • 25
-2
votes
1 answer

I want to insert this data into multiple tables from Json file into Sql table with their relation (foreign key) and link all data to one master table

Database will be having identity linked to each level of SQL. Also would like to merge data of all three table into one master table Table_master which will have final number of data based on inner element record id 2. expected to update data into…
UV283
  • 1
  • 1
-2
votes
2 answers

What is the best way of obfuscating columns in a table in SQL Server Express 2016

I have got a customers database and when I am using it in a presentation and to be on the safe side I would like to Obfuscate some sensitive data. What is the best way of doing this. I can always write a script to update a column with NewID() or…
Abe
  • 1,879
  • 2
  • 24
  • 39
-2
votes
2 answers

Setting the order for executing the stored procedures within a master stored procedure

I have a master stored procedure in which have many sub stored procedures, say 10 stored procedures. What I want is if I specify that stored procedure 1, stored procedure 2, then only these 2 stored procedures should be executed, the other 8 should…
VVN
  • 501
  • 1
  • 9
  • 21
1 2 3 4 5
6
7