Questions tagged [sql-server-express]

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

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
408 views

Permission error when executing a 5.6 GB sqlcmd file

I am trying to run a very large file through the sqlcmd command and it works perfectly with files of 100 MB up to 1.4 GB. This is what I have tested so far, but when I try to run a file which is 5.6 ...
3
votes
1answer
2k 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 ...
2
votes
0answers
63 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
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
vote
0answers
338 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 ...
1
vote
1answer
52 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
0answers
40 views

Installing SQL Server Express from SQL Server Developer Installer

If I install SQL Server 2012 Express using the SQL Server 2012 developer installer, do I still have access to all features available from the Advanced Services and/or With Tools versions of SQL Server ...
1
vote
0answers
313 views

FOR XML EXPLICIT problems in SQL Server 2005 Express

SQL Server 2005 Express Service Pack 2 w/Advanced Services Windows 2003 R2 I recently migrated a database from MSDE 2000 to MSSQL 2005 that is used for a tourist website that can be displayed in one ...
0
votes
0answers
57 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
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 ...
0
votes
1answer
71 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
0answers
40 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 ...
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
596 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)...
-1
votes
1answer
287 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 ...