Questions tagged [sql-server-express]
For questions about Microsoft SQL Server Express (except Express LocalDB).
198 questions
0
votes
0
answers
39
views
SQL Server Express programmatic installation gets stuck at "Installing..."
I'm trying to do an automated installation of SQL Server Express via powershell, aided by chocolatey.
First, I install chocolatey using the following PowerShell snippet:
Set-ExecutionPolicy Bypass -...
- 101
0
votes
0
answers
31
views
Periodic copying, synchronizing, forwarding and merging of SQL database tables with MSSQL Express?
There is a modification project in our Process Plant related to SCADA application (Process Automation System) and I am looking for reliable advice/ suggestions from experienced members related to SQL ...
1
vote
1
answer
150
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:...
0
votes
1
answer
386
views
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 ...
- 11
2
votes
1
answer
139
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 ...
- 3,287
0
votes
0
answers
76
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
93
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 ...
- 19
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
400
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 ...
- 13
0
votes
1
answer
112
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
900
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. ...
- 13
0
votes
0
answers
252
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
0
answers
149
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
591
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
467
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 ...
