14,620 questions
2 answers
Link https://go.microsoft.com/fwlink/?linkid=2216019 changed installer?
Hi, For years whe have used a script to download and install SQL 2022 EXPRESS. The link we used to download the SQL 2022 installer is https://go.microsoft.com/fwlink/?linkid=2216019 But recently the link suddenly points to a SQL 2025 Express…
SQL Server | Other
asked 2025-12-12T12:56:07.7066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 84%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jens Schumacher
0
Reputation points
answered 2025-12-12T19:02:31.6666667+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Installing Self Hosted Integration Runtime on a On Premise Database without internet access to
The system on which the database is hosted is not having internet connection. We want to connect to that database from ADF to pull the data. Please provide us the steps to install and configure the node in self hosted integration runtime.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,995 questions
SQL Server | Other
14,620 questions
asked 2024-01-12T09:57:22.9866667+00:00
Sundar Sriram Garimella
156
Reputation points
accepted 2025-12-12T16:52:38.14+00:00
Sundar Sriram Garimella
156
Reputation points
3 answers
One of the answers was accepted by the question author.
In Memory OLTP Table's indexes not releasing memory for deleted records
We have a small (logical size about 6GB) OLTP database. In it we have several work tables that during processing get filled with about 100,000+ rows. Once the calculation is complete the records are no longer needed and the data is purged. However the…
SQL Server | Other
14,620 questions
asked 2024-07-31T20:23:03.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
James Southward
25
Reputation points
answered 2025-12-12T13:57:32.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
James Cook
0
Reputation points
1 answer
SQL Server Agent not starting after installing KB5071544
My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…
SQL Server | Other
14,620 questions
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese
0
Reputation points
commented 2025-12-12T13:53:48.9733333+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
2 answers
JDBC driver 12.10 has a regression/bug for concatenated SQLStatement.
Starting JDBC driver 12.10, the following resultset will be null and seems ignore the select statement at the end. This is a regression from previous JDBC driver versions. It broke our software that has been deployed to many of our customers and…
SQL Server | Other
14,620 questions
asked 2025-07-16T22:25:29.3333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 35%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHQ%3C/text%3E%3C/svg%3E)
HAIBING Qiao
0
Reputation points
commented 2025-12-12T07:39:00.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server licensing with SA for Distributed Availability Group
I need help in understanding how many licenses I need specific to Distributed Availability Group solution below with Software Assurance benefits and purchased licenses. Region A: 3 Replicas with 2 read-write and 1 HA replica Region B: 3 Replicas with 2…
SQL Server | Other
14,620 questions
asked 2025-12-11T19:27:28.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
VYAGHRESWARUDU KOTTURI
0
Reputation points
answered 2025-12-11T21:34:29.2466667+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
2 answers
SSMS 20.2 Import Wizard Throwing Error at Server End
I was trying to use the import wizard in SSMS and found that the destination servers was throwing the above error. The error that the server administrator has sent me is: "The EXECUTE permission was denied on the object…
SQL Server | Other
14,620 questions
asked 2025-12-10T14:34:02.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Richard Williams
15
Reputation points
answered 2025-12-10T21:42:42.21+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server maintenance plans not running
None of my maintenance plans are running. They are Enabled as Recurring and scheduled to run daily or weekly, but when I select each plan and View History, they are not even attempting to run. The only History they have are the runs that I manually…
SQL Server | Other
14,620 questions
asked 2022-11-17T17:47:14.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Scott Fischer
6
Reputation points
commented 2025-12-10T16:03:52.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 54%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jacob Pitsch
0
Reputation points
3 answers
License Verification for SQL Server Express Commercial Use on AWS EC2
We are planning to install SQL Server Express Edition on an AWS EC2 instance running Windows Server and use it for commercial purposes. We would like to confirm whether this usage complies with the licensing terms. Environment details: Cloud platform:…
SQL Server | Other
14,620 questions
asked 2025-11-26T08:24:28.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Seiji Yoshida (吉田 誠司)
0
Reputation points
commented 2025-12-10T10:40:10.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
REQUEST FOR SQL DATABASE
I am currently on the get data module on power bi, I have been learning how to import data and then I have gotten to SQL relational database. for better understanding it would be good to have a SQL database to practices with. Is it possible to download…
SQL Server | Other
14,620 questions
asked 2025-12-01T08:51:10.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%3C/text%3E%3C/svg%3E)
osatohanmwen odia
0
Reputation points
commented 2025-12-10T09:01:23.09+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
4 answers
One of the answers was accepted by the question author.
SQL License Standard to Enterprise Volume license upgrade
Hi, This is regarding SQL Server licensing. One of our customers procured a SQL Server Standard Edition license about four months ago. Currently, their requirements are not being met with Standard features, and they would like to pay the differential…
SQL Server | Other
14,620 questions
asked 2025-12-09T15:12:40.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 42%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Balakrishna Medikonda
20
Reputation points
accepted 2025-12-10T03:10:51.16+00:00
Balakrishna Medikonda
20
Reputation points
2 answers
Can SQL Server 2022 Standard License Be Downgraded to SQL Server 2016 Standard?
Hello, We have purchased SQL Server 2022 Standard through an authorized distributor. Our current environment is running SQL Server 2016 Express, and we need to upgrade this instance from Express to Standard edition. Since the SQL Server 2022 Standard…
SQL Server | Other
14,620 questions
asked 2025-12-09T09:09:29.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
JINA SIM
0
Reputation points
answered 2025-12-09T22:28:05.72+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
2 answers
Invalid architecture in ODBC driver for alpine (apk)
arm64 file contains x86_64 arch package $ docker run --rm -ti alpine:3.23 sh $ uname -a Linux 24880f0978ad 6.10.14-linuxkit #1 SMP Thu Aug 14 19:26:13 UTC 2025 aarch64 Linux $ wget…
SQL Server | Other
14,620 questions
asked 2025-12-07T05:33:12.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 40%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chingis
0
Reputation points
commented 2025-12-09T16:29:59.3866667+00:00
David Engel
0
Reputation points Microsoft Employee
2 answers
License modification from SQL Server Standard to SQL Server Enterprise
Hi I am thinking about buying next licenses for MS SQL Server. First, I would like to try whether the Standard license will be sufficient for my solution, and if it turns out to be insufficient, I would like to upgrade this license to Enterprise and I…
SQL Server | Other
14,620 questions
asked 2023-07-31T18:37:50.3333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-12-09T15:37:29.6033333+00:00
Balakrishna Medikonda
20
Reputation points
0 answers
Questions regarding Microsoft SQL Server and Azure Database Certifications differences and expiration
I have a few questions regarding Microsoft certifications, particularly those related to SQL Server and Azure Database administration: I understand that Microsoft periodically retires certain certifications and exams. Could you clarify what type of…
SQL Server | Other
14,620 questions
asked 2025-07-09T12:00:36.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 33%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
Kamilia Fominova | Noewe Legal
0
Reputation points
edited a comment 2025-12-09T05:25:21.3333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 84%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
K Durga Prasanna
20
Reputation points Microsoft External Staff
0 answers
KB5058713 can not install
Hello, I have the same problem, KB5058713 can't install, it says installation error 0x851a0042, please, how can I solve it, thanks.
SQL Server | Other
14,620 questions
asked 2025-07-16T16:44:53.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 53%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXG%3C/text%3E%3C/svg%3E)
XM G
0
Reputation points
commented 2025-12-09T04:29:47.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
875
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,663 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,713 questions
SQL Server | Other
14,620 questions
asked 2024-09-19T18:36:21.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
1,390
Reputation points
answered 2025-12-08T10:17:23.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 62%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Julian Schulz
0
Reputation points
4 answers
Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded.
I am using DDD architecture and the following code changes the aggregate Root (basically adds a comment which is an Entity to the aggregate Root). public sealed class AddCommentToPostCommandHandlers : ICommandHandler<AddCommentToPostCommand,…
Developer technologies | .NET | Entity Framework Core
Developer technologies | .NET | Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
790 questions
SQL Server | Other
14,620 questions
asked 2024-11-24T08:29:09.3733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 51%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Arman Espiar
1
Reputation point
answered 2025-12-08T02:26:52.6433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Marthin Orellana Maldonado
0
Reputation points
3 answers
SQL Server Configuration Management missing protocols
I can't connect to SQL Server using a simple UDL file but I can connect to it through SSMS. I have two nodes in the SQL Server Configuration Management which does not look right and there are no Client protocols in either of those nodes. Wouldn't those…
SQL Server | Other
14,620 questions
asked 2025-12-06T13:17:46.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 14.000000000000002%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Robb
0
Reputation points
commented 2025-12-07T18:57:13.08+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
1 answer
dacpac project .sqlproj creation. errors with multiple schemas
i have SQL Server database, with objects defined under two schemas, Schema 1 - dbo. Schema 2 - pr. Tables - dbo.person, dbo.orders, pr.person , pr.orders, pr.sales SP= dbo.getpersons, dbo.getdata, pr. salesinfo. when imported the data into .sqlproj…
SQL Server | Other
14,620 questions
asked 2024-05-17T15:26:35.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ramanjaneyulu Jerugula
10
Reputation points
edited an answer 2025-12-06T13:36:17.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 70%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Fathi Ahmed
0
Reputation points Microsoft Employee