173 questions
1 answer
Issue with SQL Server 2022 RTM GDR (KB5046861) Update - Error code (Install error - 0x851a0020)
Greetings, I need help with an issue I’ve been experiencing for the past month. Below is a short description of the problem: I regularly install Windows updates, and about a month ago I encountered an issue with installing the SQL Server update…
SQL Server Database Engine
asked 2025-05-09T11:47:12.7733333+00:00
![](https://learn.microsoft.com/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(307.2, 56.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Havaji69
0
Reputation points
answered 2025-05-09T20:42:52.01+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
1 answer
How to Migrate SQL Server from One Tenant to Azure SQL VM with Minimum Downtime
we have a scenario where we have a sql server on 1 tenant that needs to be transitioned to Azure SQL Virtual Machine. Scenario: 1, Minimum down time migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022 Integration services need to be…
SQL Server Database Engine
173 questions
asked 2025-05-09T17:05:32.98+00:00
![](https://learn.microsoft.com/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(124.80000000000001, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Perera, Priyantha
0
Reputation points
answered 2025-05-09T20:32:55.45+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
1 answer
Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Suddenly getting this error when using SSMS Import/Export Wizard and importing from Excel spreadsheet.
SQL Server Database Engine
173 questions
asked 2025-05-07T19:08:52.1+00:00
![](https://learn.microsoft.com/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(19.2, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Guy Petty
0
Reputation points
edited a comment 2025-05-09T14:24:27.86+00:00
![](https://learn.microsoft.com/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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,491
Reputation points
2 answers
How to recreate sql from read transaction logs
How to read the transaction log to re-create an insert statement
SQL Server Database Engine
173 questions
asked 2025-05-08T13:14:08.5333333+00:00
![](https://learn.microsoft.com/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(163.2, 28.999999999999996%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jensen, Randy
0
Reputation points
commented 2025-05-09T05:53:12.9866667+00:00
![](https://learn.microsoft.com/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(108.80000000000001, 66%, 20%)' 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)
博雄 胡
585
Reputation points
1 answer
Trigger on cascading update target doesn't fire when the OUTPUT clause is used
Hello. I asked this question on stackexchange and the guys from the community recommended me report it to Microsoft https://dba.stackexchange.com/questions/346386/trigger-on-cascading-update-target-doesnt-fire-when-the-output-clause-is-used Below is the…
SQL Server Database Engine
173 questions
asked 2025-05-05T09:50:45.2+00:00
![](https://learn.microsoft.com/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(291.2, 68%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Igor Telegin
0
Reputation points
commented 2025-05-08T16:21:05.5733333+00:00
Igor Telegin
0
Reputation points
1 answer
Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)
Details: I am running Microsoft SQL Server 2022 I am running DBCC CHECKDB on a user database (of which raised this error), each saturday This has happened on one on-prem Windows Server with installation of SQL server, with a predefined set of…
SQL Server Database Engine
173 questions
asked 2025-05-07T08:39:20.11+00:00
![](https://learn.microsoft.com/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(12.8, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lucas Bjorndal
0
Reputation points
answered 2025-05-08T07:22:23.6533333+00:00
Lucas Bjorndal
0
Reputation points
0 answers
Cyber Attack or Account Compromized
Hi, Someone deleted my SQL Database instance name 'CroLahoreDB' early today 08:33 am, I want to know that how is it possible either it is cyber attack or my Account is compromized or some virus? How can I check it? please guide me. Regards Mubashir Ali
SQL Server Database Engine
173 questions
asked 2025-05-07T10:59:26.3033333+00:00
![](https://learn.microsoft.com/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(182.40000000000003, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mubashir Ali
0
Reputation points
commented 2025-05-07T21:03:11.0666667+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
0 answers
SQL Stretch DB - error Msg 40673, Level 16, State 1, Line 24
Hi when setting up StrechDB from an on prem server i get the error below Msg 40673, Level 16, State 1, Line 24 The service objective assignment for the database has failed This happens when i run the following script ALTER DATABASE XXXXXXX SET…
SQL Server Database Engine
173 questions
asked 2025-05-07T17:36:13.0966667+00:00
![](https://learn.microsoft.com/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(96, 33%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Arthur Moulding
0
Reputation points
commented 2025-05-07T20:52:46.9233333+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
1 answer
One of the answers was accepted by the question author.
the file %commondir%\dte80.olb could not be loaded
Hi .. Today I woke up and just open the server and start SQL server manegment studio and I received this message "the file %commondir%\dte80.olb could not be loaded an attempt to repair this condition failed because the file could not be found…
SQL Server Database Engine
173 questions
asked 2025-05-05T18:29:25.52+00:00
![](https://learn.microsoft.com/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(166.4, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hussam Homsi
20
Reputation points
commented 2025-05-07T20:46:46+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
0 answers
SSMS not showing Attach Database/Locate Database Files Dialog DIR Tree.
I am unable to Attach a Database in SSMS. The Locate Database Files Dialog text is frozen on a USB port folder that no longer exists. Even entering a dummy database file *.mdf, the OK button does not enable. When I tried to repair SSMS, Error message;…
SQL Server Database Engine
173 questions
asked 2025-05-07T12:34:09.6366667+00:00
![](https://learn.microsoft.com/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(147.20000000000002, 28.000000000000004%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shane P. Watson
0
Reputation points
asked 2025-05-07T12:34:09.6366667+00:00
Shane P. Watson
0
Reputation points
2 answers
MSSQL connection in Visual Studio Mac->(Socket Exception)
HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…
SQL Server Database Engine
173 questions
0 answers
Request for API Integration to Auto-Create ServiceNow Incidents from SQL Server Alerts
Hi Team, I’m currently managing our MSSQL environment at Tech Mahindra, and I’d like your guidance on integrating ServiceNow with SQL Server using APIs. As of now, we are receiving all alert notifications (job failures, maintenance job issues, etc.) via…
SQL Server Database Engine
173 questions
asked 2025-05-07T05:29:25.3866667+00:00
![](https://learn.microsoft.com/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, 23%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Duggina, Balavenkatasaivamsi (EXTERNAL)
0
Reputation points
commented 2025-05-07T05:55:42.6466667+00:00
Duggina, Balavenkatasaivamsi (EXTERNAL)
0
Reputation points
1 answer
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476
Microsoft.Data.SqlClient.SqlError: Cannot use the backup file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Backup\Surveillance.bak' because it was originally formatted with sector size 512 and is now on a device with sector size 4096.…
SQL Server Database Engine
173 questions
asked 2025-05-06T08:50:55.15+00:00
![](https://learn.microsoft.com/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, 14.000000000000002%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
sinesh hari
0
Reputation points
answered 2025-05-06T21:00:10.14+00:00
Erland Sommarskog
120.4K
Reputation points MVP
Moderator
1 answer
One of the answers was accepted by the question author.
SQL Server MAXDOP - server vs database scope
I have multiple databases for one app running on a dedicated SQL 2019 instance (Always On primary replica). The server MAXDOP setting is 8. The individual databases are set to 0. If I want the databases all to be 5, should I change them to 5…
SQL Server Database Engine
173 questions
asked 2025-05-06T16:09:46.94+00:00
![](https://learn.microsoft.com/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(121.6, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cooper, David A. [ISS] (Contractor)
111
Reputation points
accepted 2025-05-06T16:42:57.65+00:00
Cooper, David A. [ISS] (Contractor)
111
Reputation points
0 answers
Availability Group is not connecting through Listener
I have set up 2 SQL VMs on Azure with VPN we connect to those VMs and it is a single subnet , No Public IP is used. but the listener is only accessible from Node1 when Node1's Availability group is primary and the listener is not accessible from Node1…
SQL Server Database Engine
173 questions
0 answers
summary.txt after rebuild the system database.
I ran the following command to rebuild the system database X:\Backups\2019>setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myusername Microsoft (R) SQL Server 2019 15.00.2000.05 Copyright (c) 2019 Microsoft. …
SQL Server Database Engine
173 questions
asked 2025-03-05T23:49:04.68+00:00
![](https://learn.microsoft.com/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(246.4, 18%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bestrongself
1
Reputation point
edited the question 2025-05-06T10:57:27.1966667+00:00
![](https://learn.microsoft.com/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(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
14,015
Reputation points Microsoft External Staff
Moderator
0 answers
SQL Server 2022 Oops... Error decompressing SQL Server media
Hello, I am trying to install SQL Server 2022 for the first time, but it gives me this error. I spent about 10 days to find the main cause of this problem and try to solve it, but it seems that is a new one. I tried to: remove .exe installation file…
SQL Server Database Engine
173 questions
asked 2025-03-19T05:34:13.0433333+00:00
![](https://learn.microsoft.com/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(291.2, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahmoud Khaled
0
Reputation points
edited the question 2025-05-06T10:24:05.1533333+00:00
VarunTha
14,015
Reputation points Microsoft External Staff
Moderator
0 answers
Understanding SMTP Authentication in SQL Database Mail Configuration
In the SQL Database Mail Configuration Wizard, basic authentication is currently being used. Does this imply the use of interactive or non-interactive login? Some articles suggest that providing a username and password constitutes interactive login,…
SQL Server Database Engine
173 questions
asked 2025-05-06T08:24:08.3066667+00:00
![](https://learn.microsoft.com/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(300.8, 20%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Praneeth Eranti
190
Reputation points
asked 2025-05-06T08:24:08.3066667+00:00
Sai Praneeth Eranti
190
Reputation points
2 answers
Is a license required for SQL Server Express?
I understand SQL Server Express is free but is a license required to install and use SQL Server Express?
SQL Server Database Engine
173 questions
asked 2025-05-05T17:10:59.1866667+00:00
![](https://learn.microsoft.com/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, 35%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIL%3C/text%3E%3C/svg%3E)
Is license required for SQL Server Express?
0
Reputation points
answered 2025-05-06T05:24:05.57+00:00
Olaf Helper
46,641
Reputation points
1 answer
Why has SQL Server's ranking been falling behind
Why has SQL Server's ranking been falling behind and may be overtaken by PostgreSQL in a few months since the dbengine website was acquired by Redgate? What do you think are the reasons?
SQL Server Database Engine
173 questions
asked 2025-05-05T06:31:31.3666667+00:00
![](https://learn.microsoft.com/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, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Steven Lam
20
Reputation points
answered 2025-05-05T15:18:39.42+00:00
![](https://learn.microsoft.com/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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
75,306
Reputation points
Moderator