Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

Install LocalDB feature with SQL Server Express as a CLI feature argument

We have been trying to install SQL Sever Express with all the necessary features using the CLI, it seems that LocalDB is not being installed. This is what the flags look like: '/ACTION=Install /...
1
vote
0answers
17 views

Last year's totals won't group by hour

I have a PowerShell script with a query to display yesterday's totals, as well as last year's same day totals, by hour for comparison. Yesterday's totals display by hour fine, but last year's list the ...
4
votes
1answer
239 views

No parallelism in Express Edition of SQL Server

I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property. Is it ...
0
votes
4answers
46 views

MS SQL Express - Find when a Query was run

I have an ecommerce website in .NET and using MS SQL Server Express, Version info: Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Express ...
0
votes
1answer
40 views

Can no longer connect to localdb after updating from Sql Server 2016 to 2019

I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I download and installed SQL Server Express 2019 and uninstalled the older version. ...
2
votes
2answers
76 views

How to allow a certain domain user to create databases on a remote SQL instance?

I want to allow for a certain domain user to be able to create databases on a remote SQL instance. What steps are necessary and is it possible to perform those steps programmatically in a C# ...
-1
votes
1answer
29 views

Is there any possibility to use SMO objects to copy a database from MS SQL Server 2014 Express (server address) to localhost?

I need to implement in c# a functionality for copying a certain database from server address to localhost (I'm aware of the backup/restore option - I have this implemented when I want to export and ...
0
votes
1answer
45 views

What is the available SQL Server Express database size? [duplicate]

SQL Server Express allows the maximum of 10GB/10240MB for a database size. I have a database which currently is ~8000 MB in size. The unallocated space is ~7000 MB. The question is: how many megabytes ...
0
votes
1answer
86 views

Creating Linked Server Object to same instance

I'm trying to create a Linked Server Object back to the same SQL Express 2014 server instance (see below for the context), but I'm hitting the following error... Cannot initialize the data source ...
2
votes
0answers
131 views

Sql Server Express edition - Could not allocate space for object [Table] in database [DB] because the 'PRIMARY' filegroup is full

I have reached the Sql Server Express edition limit of 10 Go of space per database and for every new INSERT I have this error : 2020-08-10 14:21:58.75 spid67 Could not allocate space for object [Table]...
1
vote
2answers
34 views

SQL Server Express Edition feature and upgrade concerns

I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is the Express Edition 2017. Will the express edition support procedures, triggers, dynamic sql, PIVOT, ...
9
votes
1answer
639 views

Why the instance name of SQL Server Express is changing?

I'm workig on a web app which is using SQL Server Express (Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Express ...
0
votes
0answers
258 views

MSSQL Express: linked server from Access database on network path

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I have trouble to set the appropriate network UNC path and other settings for the linked server. My ...
0
votes
1answer
100 views

SQL Server Express 2008R2 - restore db failing due to size limit, but file is under 10GB

I'm trying to restore a live db to a test db, but I keep getting a '..failed because the resulting cumulative db size would exceed...limit of 10240' error, yet my database is under 10GB, I feel like ...
2
votes
2answers
761 views

How to install SQL Server 2017 Express in “Quiet Simple” mode without an extraction folder?

I need to install SQL Server 2017 Express with as little user interaction as possible. I am using the SQLEXPR_x64_ENU.exe setup file that I found a Microsoft download for. The installer I am currently ...
3
votes
2answers
102 views

Regarding Sql server 2014 express edition

I need to know if adding another data file in a database (let say MYDB) in express edition will have another 10 GB size or 10 GB will be the total size of all the data files we add in a database. ...
0
votes
3answers
226 views

Does SQL Server 2017 Express install on Dual CPU server?

A customer wants to rent a dedicated Server for their site. They do not need more than SQL Express 2017, for the time being, but they have been offered a dual Xeon system. Does SQL Express install ...
1
vote
2answers
47 views

Backing up SQL Server Express Edition on a VPS

I'm considering installing SQL Server Express Edition on a VPS. My understanding is that, among the limitations of Express Edition, some of them involve features that facilitate backups. Can someone ...
1
vote
1answer
20 views

In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?

We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
0
votes
1answer
395 views

Sql Server - Multiple errors regarding to memory in error log

MSSQL-Server 2017 Express Edition runs on my Linux server. The server has 4GB RAM. The total size of DB is 300MB. My website and the sqlserver are on the same server, it's a small website with max of ...
0
votes
1answer
65 views

Database Consistency History fails in SQL Server 2017 Express

When I run the Database Consistency History report using MSSM I get an error message: unable to retrieve data for this section of the report. Following error occured Msg 19050, Level 16, State 5 ...
2
votes
2answers
4k views

‘PRIMARY’ filegroup is full. How do I increase temdb size in SQL Server Express 2017?

When I reindex a particular table DBCC DBREINDEX(@TableName, '',90) I get an error Level 17, State 2, Procedure aareindex, Line 21 [Batch Start Line 0] Could not allocate space for object ‘...
0
votes
1answer
29 views

After new row INSERT statement, use newly created PK as FK in a second INSERT statement within the same Stored Procedure

Using SQLExpress -- I have a table Orders that contains a PK of order_id. I have a second table Items that contains model and quantity along with a FK of order_id. I am using a gridview to collect ...
2
votes
2answers
495 views

Cannot find Database Mail feature in SQL Server Express 2012 SP1

I need to use SQL Server Database Mail feature in my project. However Database Mail seems not available on my development instance. There should be a 'Database Mail' node in the Object Explorer. In ...
0
votes
1answer
95 views

Command runs fine in elevated command prompt, but fails when run in a Windows Task Scheduler task

Here's my predicament: The version on the server is SQL Server Express. And no, we cannot use any other version. (Long story, but: vendor will not allow without $ome...) From 1, you can deduct that ...
4
votes
1answer
1k views

Scripting a Maintenance Plan in SQL Server Express

How would I run each aspect of Ola Halengren's sql maintenance plan on SQL Express? It's my understanding that each job should be run in a specific order. I'm sure that a .bat or cmd file can do ...
0
votes
0answers
50 views

Migrating SQL Server 2012 Web Edition to Azure

I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
1
vote
1answer
101 views

What is using all my space?

I'm using SQL Server Express 2008 R2 and a third part application has its database on this database server. The database seems way bigger than I would expect considering what it is actually doing. ...
2
votes
1answer
153 views

Reviewing the design of a database about animals of two distinct species

I am creating a small database using SQL Server Express 2017. There are two animals (Foxes and Elephants). The Foxes table will have the columns: Identifier, Species, BodyLength, and FurColour. The ...
11
votes
1answer
21k views

Messages about parallel redo

Parallel redo is shutdown for database '' with worker pool size [2]. Parallel redo is started for database '' with worker pool size [2]. Starting up database '' I see this on a client PC a lot in ...
1
vote
0answers
477 views

SQL Server Express 2017 database size limitation

I have a database hosted on SQL Server Express 2017. The size was small like 200MB. Today I have copied 24GB tables to the same database from external database hosted on different server. The ...
3
votes
1answer
2k views

Is there an Express version of Azure SQL DB?

With on-premise SQL Server, there are editions such as Express, Web, Standard, and Enterprise. Do those editions (or an analog) exist in Azure SQL DB, especially Express? My Google-Fu is failing ...
2
votes
1answer
805 views

Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely

I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
0
votes
1answer
890 views

How to trace security_error_ring_buffer_recorded errors in SQL Server 2014 Express

Just so everyone doesn't have a high expectation of my level of knowledge on this topic, I'm not a DBA; I'm a .NET developer who has to try and figure this out by virtue of being "the one most likely ...
0
votes
0answers
36 views

Database Mail on SQL Server Express 2017 [duplicate]

I followed this article to create a database mail for SQL Server Express 2017. I got it working but before that I had tried to create accounts and different profiles. How I do I list all database ...
-1
votes
2answers
109 views

SQL Server Express 2017 Database Mail Silent error

I have made an installation of a development environment in VMWare that contains: Windows Server 2016 SQL Server Express 2017 The objective is to perform migration tests of a base that is currently ...
1
vote
2answers
179 views

Shrinking a SQL Server 2008 Standard database to move it into SQL Server 2014 Express

I need to shrink a popular CRM database with SSMS to move it onto a new server. I am going from SQL Server 2008 Standard to SQL Server 2014 Express. Database is in Simple Recovery Model. It needs to ...
-1
votes
2answers
76 views

What permissions should be added to public users sql [closed]

I have a SQL Server and am looking at making it public. What I mean by this is: I can create a DB and give access to myself and friends etc. I need to create a login which can only view databases it ...
2
votes
1answer
5k views

Maximum concurrent connections to SQL Server Express 2017 installed on Windows Server 2016 Essentials

If I install SQL Server Express 2017 on Windows Server 2016 Essentials, what is the maximum number of users that will be able to connect concurrently across the network to the SQL Server Express ...
0
votes
2answers
59 views

backup the difference with sql server express between 2 timestamps

I am newbie to sql and have sql server express edition installed on my PC and contains a database 'Jdatabase' on 1sept and took a backup(by right clicking on database -> tasks->backup using 'sql ...
1
vote
1answer
56 views

One instance, four clients, one is slow

We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
1
vote
1answer
115 views

SSRS 2016 on SQL Server 2014

I have question about using SSRS 2016 on SQL server 2014 First of all, I don't have much experience with Reporting services. Company use SQL server 2014 and they have SQL database on it (DB is ...
-1
votes
1answer
430 views

SQL Maintenance script not running with SQL Server Express

Hello and thank you for making such a well-designed script available to the public. I have client with some heavy db fragmentation and performance issues. I would like to use your scripts to help ...
1
vote
3answers
5k views

Couldn't find sql server agent in Sql Server 2014 Management Studio?

Is there any way to add it in SQL Server Express edition?
5
votes
2answers
718 views

Enabling admin connection on SQL Server Express to fix logon trigger

Well, luckily I got this error on my test environment. I'm so scared about this error that I disabled all logon triggers I was using on production environment. I created the famous logon trigger, ...
5
votes
1answer
9k views

SQL Server Express Instance Memory vs Memory Limit

SQL Server 2014 express edition is published as having a memory limit of 1 GB. What do the SQL Instance Memory Properties do with respect to this limit? For example, I can set the minimum and maximum ...
4
votes
2answers
1k views

Replicate single table from SQL Express to SQL Enterprise 2014

We have a small branch app that stores some data in a SQL Express Database. We want to have an almost real time copy of this table in our headquarters, were we have SQL Enterprise 2014. I say almost, ...
0
votes
1answer
194 views

Define relationships for 3 tables

I have 3 tables that are currently defined as: Is this the best way, or should I use an associative table? I put the relationships backwards, 1 group can contain many users and many students. There ...
0
votes
0answers
2k views

NLShimImpersonate Error 5023 - SQL Server Express - AWS RDS

I'm seeing a ton of these security_error_ring_buffer_recorded, error 5023, events in my AWS RDS SqlExpress instance. I noticed this while trying to investigate timeout errors I started getting in my ....
0
votes
1answer
698 views

SQL Express 2014 Installation Fails with SSL Error

I've got a user that wants to install SQL Server Express 2014 on his Windows 10 laptop. The default installation fails: 2017-11-13 13:39:31.31 Server Microsoft SQL Server 2014 - 12.0.2000.8 (X64)...