Questions tagged [sql-server-express]
For questions about Microsoft SQL Server Express (except Express LocalDB).
195 questions
2
votes
1
answer
105
views
SQL Express CPU limitation ignored
I have a SQL Express 2014 running on a VM with 12 cores
SQL Express limitations state that it should be limited to either 4 cores or 1 socket, but when I run this query:
select count(1) "Nb ...
- 35.5k
1
vote
1
answer
101
views
SQL Server Express mdf file is 50+gb
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run select @@version I get:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:...
- 90.3k
0
votes
2
answers
265
views
Yet another Replicated transactions are waiting for next Log backup or for mirroring partner to catch up
We have a partial transactional replication setup in our environment to make a data subset available to another application.
Application Server 1 -> Tables1.row1/row2/row3 -> Application Server ...
- 26.9k
0
votes
0
answers
59
views
OPENROWSET in Linux container as AD account
We are building a pseudonymization solution as sort of a proxy between on-prem SQL Server and Azure Data Factory to pull things to the cloud. The pseudonymization parts of it are already on their way ...
- 1
0
votes
1
answer
52
views
Upgrade SQL Server Server Express to Licensed Enterpise edition?
we have sql server express edition 2017 with default instanc ,now we want to upgrade it to Enterprise Licensed Edition 2017 with default instance in the same server
At first I thought I had to ...
- 39.5k
0
votes
0
answers
24
views
I need to create a SQL Server 2019 Express database from a SQL Server 2022 database [duplicate]
I have developed a database in SQL Server 2022 (and have SSMS), I need to recreate and include all data from that database on a different server which contains SQL Server 2019 Express.
When in SSMS, I ...
0
votes
1
answer
267
views
SQL Server Replication Licensing
Production database is hosted on a SQL Server Standard instance and is replicated using merge replication with web synchronization to 10 subscriber databases hosted on 10 separate SQL Express server ...
- 491
0
votes
1
answer
66
views
Is there a way to automate back-up on SQL Express LocalDB?
I am new to the gis world, and my boss wants me to find a way to automate the process to create back-ups on a local SQL Express DB. I know that I can create one for nonlocal DBs, however, I was ...
ANON
1
vote
1
answer
641
views
SQL Server 2019 Express limited to 1 socket/4 cores per instance. Can different instances then use different sockets?
We have a SQL Express 2019 server with 3 instances.
The VM has 2 sockets each with 2 cores. The SQL Express licensing specifies that a SQL Express instance can use the lessor of 1 socket or 4 cores. ...
- 47.6k
5
votes
4
answers
61k
views
How to automatically execute a stored procedure every day at a particular time?
Can you please help me how to execute a stored procedure automatically in SQL database without any transaction in SQL? I want to execute on particular fix time.
0
votes
0
answers
190
views
How to copy a database to another server with only some of the rows
Trying to copy a database from a hosted server to a local server for testing purposes and am trying to avoid exporting the whole database as a .bacpac file as there are some tables with tens, maybe ...
Maen Enma
0
votes
1
answer
519
views
SQL Server Express Limitation
I would like to use Express instead of Standard. Does Express still have the annoying habit of going to sleep if left unused for a period of time?
- 2,201
0
votes
0
answers
130
views
install database backup from SQL Server 2017 to local PC with SQL Express 2022
I am assisting a client who has recently retired from his original business and is setting up a smaller professional property management partnership.
He has been instrumental in setting up a tailored ...
2
votes
1
answer
453
views
Stored procedure times out despite very low cpu_time and logical reads/writes
I'm developing a service locally that uses SQL Server Express as a database. I'm seeing strange behavior where a stored procedure is executing several times in a row (with different parameters), and ...
- 121
0
votes
1
answer
378
views
Move SQL Express 2014 database to existing SQL Server 2019 Standard Instance
I have a SQL Express 2014 instance on a server with 1 database that has 1 table. I would like to move that database to an existing SQL Server 2019 Standard instance that is on a different server. The ...
- 425
0
votes
2
answers
394
views
Database not shrinking and cant insert data even thought file has free space
I have SQL Server Express 2019 on my local system on a large SSD with >50Gb free disk space.
I had a 14Gb database on production, which I copied, deleted a bunch of old data, and reduced the size ...
- 34
18
votes
1
answer
75k
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 ...
- 90.3k
3
votes
2
answers
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 ...
- 2,201
1
vote
1
answer
1k
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)...
CommunityBot
- 1
1
vote
1
answer
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,201
5
votes
1
answer
4k
views
SQL Server 2008 R2 Upgrade (Express to Standard) fails. No "Select Instance"
I got stuck in the progress of upgrading 3 systems from SQL Server 2008 R2 Express Edition --> SQL Server 2008 R2 Standard Edition.
Problem
The Option "Select Instance" in the Upgrade ...
- 90.3k
0
votes
1
answer
648
views
Can not enable lock page in memory in SQL Server Express edition
For enabling Lock Page In Memory, I tried to do this: first of all I find my SQL Server account name with this code:
SELECT service_account
FROM sys.dm_server_services
This code returns:
NT Service\...
0
votes
0
answers
1k
views
SQL Error: Could not find stored procedure 'sp_cleanup_history_table'
Seeing errors in the SQL error log hourly on a recently patched SQL Express 2017 CU26 instance. Errors are below.
Feels like something system generated from the stored procedure name but very little ...
- 61
0
votes
2
answers
11k
views
How to increase database size in Microsoft SQL Server Express?
I have downloaded Microsoft SQL Server Express version. I have created a database name ArcGIS. By default, it has provided me space of 16 MB, see pic. I would like to increase the size of this ...
- 4,160
1
vote
1
answer
678
views
Does SQL Server 2019 automatically un-compress data when it is queried by an application? [duplicate]
We are using SQL Server Express 2019 and have inevitably ran into the 15GB cap. I now have to figure out a way to quickly compress data since we cannot buy a license at the moment.
At the moment it is ...
- 39.5k
-1
votes
1
answer
916
views
Recovering SQL database when OS crashed
I was working on a DB design its almost finished. But missed to take a backup.
While working due to some reason my OS got crashed (Win 10) and nothing helped to recover it.
But I am able to access the ...
- 39.5k
13
votes
1
answer
14k
views
Move folder of SQL Server LocalDB instances from the default location
I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
- 90.3k
4
votes
1
answer
566
views
SQL Server Express averages 2-3% CPU but gets stuck at 100% sometimes
Skip to the last paragraph for the summary-version
I am dealing with a SQL Server 2008 R2 Express installation. I have a fairly complex stored procedure. Depending upon the inputs, it may return 6500 ...
- 143
1
vote
0
answers
31
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 ...
- 90.3k
4
votes
1
answer
883
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 ...
- 2,018
4
votes
2
answers
16k
views
How to attach an .mdf file that was not properly detached?
One of our clients had a SQL Server 2000 database, on a system which is no longer running. They have no idea what was in the database. They have given me the .mdf and .ldf files, and want us to ...
CommunityBot
- 1
0
votes
4
answers
107
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 ...
- 5,926
5
votes
4
answers
7k
views
Automate daily backup of database
I am trying to create automate/daily backup of database in SQL Server 2008 R2. I did bit of research and I get to know that as I am using Express edition; which doesn't come with Maintenance Plan, I ...
2
votes
2
answers
760
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# ...
- 69.5k
-1
votes
1
answer
551
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 ...
- 39.5k
0
votes
1
answer
2k
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 ...
- 39.5k
0
votes
1
answer
951
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 ...
- 217
0
votes
1
answer
2k
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 ...
CommunityBot
- 1
2
votes
0
answers
714
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]...
- 121
1
vote
2
answers
49
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, ...
- 47.6k
9
votes
1
answer
899
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 ...
- 16.3k
1
vote
2
answers
2k
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
2
answers
637
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 ...
- 182k
1
vote
1
answer
209
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 ...
- 182k
1
vote
1
answer
4k
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 ...
- 182k
1
vote
1
answer
1k
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 ...
- 182k
0
votes
0
answers
900
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
1
answer
348
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 ...
CommunityBot
- 1
2
votes
2
answers
3k
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 ...
- 898
3
votes
2
answers
263
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. ...