Questions tagged [sql-server-express]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
77 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 ...
0
votes
1answer
25 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 ...
3
votes
1answer
3k views

SQL Server 2016 Linked Server OPENQUERY Hangs

I've been trying to figure out this linked server problem for about a week now with no luck. The set up I have is a linked server from an instance of SQL SERVER 2016 to an instance of SQL SERVER 2016 ...
0
votes
1answer
634 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)...
8
votes
1answer
16k 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 ...
0
votes
1answer
24 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 ...
0
votes
1answer
801 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 ...
2
votes
0answers
82 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
33 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
618 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 ...
1
vote
2answers
718 views

What determines the maximum number of concurrent connection to SQL Server 2016 Express

After some googling, there seems to not have a straight forward answer to the question. MSDN Forum mentions it depends on CPU, Memory usage, database size etc. Could someone help explain or perhaps ...
1
vote
2answers
615 views

Table not dropped correctly in SQL Server Express 2008

I've dropped a table but it is still listed in sys.tables. What's more confusing is that I can create the table again as one user, but if I log in as another user with the same permissions, I can't (I ...
1
vote
1answer
207 views

Unable to view SQL Server services

Whenever I enter SQL Server Configuration Manager and choose SQL Server Services I would always get the following error message: "The remote Procedure call failed. [0x800706be]" everything else works ...
1
vote
1answer
2k views

SQL Server Express support for TLS1.2

I have installed SQL Server 2014 Express Edition ( 12.0.2000.8 x64 ) on a Windows server 2012 machine. Because of the POODLE vulnerability, our IT department is going to disable TLS 1.0 and all ...
1
vote
1answer
721 views

Failed to attach SQL Express DB, Could not continue scan with NOLOCK

We have a remote client that had to rebuild their server and has been having trouble with their SQL Express database since. I cannot remotely connect to this client unfortunately. I had them run "DBCC ...
0
votes
0answers
117 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
69 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
530 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
94 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. ...
6
votes
3answers
12k views

SQL Server Express 2012 Database Size Limit

I checked the forum there are other similar topics but my scenario is different. for myDatabase under database properties -> General tab it shows: Size : 25285.31 MB Space Available: 3989.13 MB And ...
0
votes
3answers
153 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
43 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 ...
-1
votes
1answer
336 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 ...
0
votes
1answer
267 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
53 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
2k 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
1answer
121 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 ...
2
votes
2answers
374 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 ...
3
votes
1answer
1k 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 ...
4
votes
1answer
998 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
44 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
79 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. ...
1
vote
0answers
366 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 ...
8
votes
4answers
37k views

Restore backup fails - not enough disk space [duplicate]

I have a backup that's about 6Gb. It's a "light" backup of the original (with the log tables purged), which is about 14Gb. I try to restore the backup on my SQL Express local server. It fails with a ...
3
votes
2answers
15k views

How to install SQL Server Management Console in 2008 Express Version?

I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server. What i use: Windows Vista 2007 SP 2 What i did: a) I downloaded the install file ...
1
vote
1answer
55 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 ...
2
votes
1answer
694 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
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
106 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
72 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
4k 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 ...
0
votes
2answers
86 views

Mark exported rows as exported

I need to write an export module which marks exported rows as exported. We currently run SQL Server Express 2012, but may switch to Oracle, so I need a client-side approach. We are currently using ASP....
1
vote
2answers
572 views

Feature of database-level audit in SQL Server 2012 Express edition

Like in SQL Server 2012 Enterprise edition, can we have database-level audit in SQL Server 2012 Express edition? Can we have Audit Folder in Security Tab?
1
vote
1answer
103 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
vote
1answer
136 views

Requirement of SQL Server 2008

The software I am installing requires SQL Server 2008. I have SQL Server 2008 R2 Express Version. I am having problem in the setup and finally I am arriving on the conclusion that my SQL Express can ...
2
votes
1answer
6k views

Install SQL Server Express without administration rights

Is there a way to install SQL Server Express without administration right? Is there a portable version? (I need to test SQL Server on my computer before using the server but I don't have ...