536 questions
2 answers
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…
SQL Server Database Engine
asked 2025-12-12T12:06:09.9233333+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(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
20
Reputation points
answered 2025-12-12T19:06:53.2333333+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Unreliable Microsoft.ACE.OLEDB.12.0. Excel import works sometimes
Hello I have a query that works all the time, 100 % success. I have a second one, with a different Excel file, that works the first 2 or 3 times I run it in a row. After that, the next run will run indefinitely and any other attempt at running any…
SQL Server Database Engine
536 questions
![](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(89.60000000000001, 31%, 18%)' 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)
2 answers
One of the answers was accepted by the question author.
Can I install SQL 2008R2 on server with TLS1.2 or higher enabled
Hello, I have a requirement to upgrade SQL 2000 databases. I am thinking to install SQL 2008R2 , restore SQL 2000 backup file on SQL 2008R2, upgrade database ( provided it goes through). If successful, i will upgrade it further to SQL 2016 or SQL 2019,…
SQL Server Database Engine
536 questions
asked 2025-12-02T16:24:47.6533333+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, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mudit Gupta
101
Reputation points
commented 2025-12-12T15:08:52.09+00:00
Mudit Gupta
101
Reputation points
3 answers
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…
SQL Server Database Engine
536 questions
asked 2025-08-13T13:50:03.2533333+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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alex Kipritsis
1
Reputation point
commented 2025-12-12T13:27:56.99+00:00
Alex Kipritsis
1
Reputation point
2 answers
Trouble configuring SQL Server Always On
I have created an AD setup. Joined two sql vms(primary and secondary) into that AD. I have then installed failover clustering on both the sql nodes, and created a cluster. Then I have enabled SQL Server Always On Availability Groups. Next, while…
SQL Server Database Engine
536 questions
asked 2025-12-08T13:21:50.4033333+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(230.39999999999998, 75%, 32%)' 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)
Sree Harshita Maddala
0
Reputation points
edited an answer 2025-12-12T11:52:44.1266667+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
1 answer
begin stack dump error no sql server 2012
Tenho um micro com Windows Server 2008 R2 enterprise com o SQL Server 2012. Este vem apresentando falha. No Event Viewer aparece esta mensagem: The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 8 time(s). No log do SQL, no…
SQL Server Database Engine
536 questions
asked 2025-12-03T10:51:55.7+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rodrigo de Oliveira Gomes - PrestServ
0
Reputation points
commented 2025-12-12T11:10:27+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
4 answers
SQL Configuration step issue in Ubuntu Instance
While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…
SQL Server Database Engine
536 questions
asked 2025-12-04T05:16:29.8166667+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(12.8, 23%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Pratik Narottam Panchal
0
Reputation points
commented 2025-12-12T10:50:38.8866667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
Wait on the Database Engine recovery handle failed
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2025-12-07 16:55:50 End time: 2025-12-07 16:59:41 Requested action: …
SQL Server Database Engine
536 questions
asked 2025-12-07T11:39:56.8733333+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(108.80000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Zapadiya, Prahlad
0
Reputation points
commented 2025-12-12T10:45:53.7+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2022 CU18 Crashing with EXCEPTION_ACCESS_VIOLATION
SQL Server 2022 CU18 is experiencing crashes approximately 1-2 times a month since installation. The error log shows the following message: 2025-03-18 08:20:04.77 spid70 SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005…
SQL Server Database Engine
536 questions
asked 2025-03-18T23:00:19.1266667+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-12T07:48:11.58+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
Microsoft Entra ID not working in SQL Server VSCode
Whenever I try to use my Microsoft Entra ID on the SQL Server extension in VSCode, I click 'Sign in', which takes me to the authentication page in my browser where I sign in. I get the page that says I am signed in and can close the browser, but the…
SQL Server Database Engine
536 questions
asked 2025-07-11T17:39:09.76+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(160, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Carlos Casellas Garza
5
Reputation points
commented 2025-12-12T07:43:51.5133333+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
Missing Client Protocols in SQL Server Configuration Manager
I installed SQL Server 2025, but when I try to enable TCP/IP from SQL Server Configuration Manager, the Client Protocols field is empty. I've tried everything: uninstalling, reinstalling, checking ports, using snap-ins—I'm at a loss. I have the correct…
SQL Server Database Engine
536 questions
asked 2025-12-03T23:41:08.02+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, 10%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Serrato, Mario
0
Reputation points
edited a comment 2025-12-11T21:06:00.9933333+00:00
Serrato, Mario
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Readable mirror database on Database mirroring
Hi expert, is Mirror database readable on Database Mirroring concept ? if YES, how to set it? great thanks & appreciation best regards, Urbel
SQL Server Database Engine
536 questions
![](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, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
1 answer
HOW TO FIX SQL SERVER(Local Instance MYSQL80)
MY SQL SERVER IS NOT RUNNING AND IT IS NOT CONNECED
SQL Server Database Engine
536 questions
asked 2025-12-03T07:13:45.21+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, 24%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
Isha Jangid
0
Reputation points
commented 2025-12-10T11:58:35.86+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.
hi, hi, i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT…
SQL Server Database Engine
536 questions
asked 2025-12-10T10:50:27.08+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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
291
Reputation points
commented 2025-12-10T11:32:53.88+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
how fix the error that occurs when I try to install SQL Server 2019
The following is the error message that I keep getting each time I tried to install SQL Server 2019: Unable to install SQL server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check…
SQL Server Database Engine
536 questions
asked 2025-12-02T13:56:13.8866667+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(44.800000000000004, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
CJAY Nwadinobi
0
Reputation points
commented 2025-12-10T10:46:45.8833333+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
3 answers
Setting Up Microsoft SQL Server on New Device
Hello, I recently set up MS SQL Server on a new computer. On my old machine, the server name was OLDCOMPUTER#\SQLEXPRESS and it used Windows Authentication with the username OLDCOMPUTER#\atsuser. On the new computer, the username is based on the new…
SQL Server Database Engine
536 questions
asked 2025-11-25T20:52:04.0366667+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(176, 37%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dana Slepyan
0
Reputation points
commented 2025-12-10T07:57:17.6866667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
BROOOOO I am trying to install sql server 2022 version but its saying fare wall warning no matter how many help i saw i couldnt just figure out the problem please help me
Bruhhhh Why cant i find the goddamn problem! i been trying to install the sql server but everytime i am stuck at Install Rules where there is a Windows farewell warning!!! Eventough i install it anyways i have a problem at Installation process where it…
SQL Server Database Engine
536 questions
asked 2025-11-20T17:48:38.0933333+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(304, 0%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sanjana velicheti
0
Reputation points
commented 2025-12-10T07:45:29.76+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
What happens to my account when the Volume Licensing Service Center (VLSC) is replaced by the Microsoft M365 Admin Center?
ボリューム ライセンス サービス センター(VLSC) からMicrosoft M365 管理センターに変わったため、SQLサーバ2008R2や、2019のボリュームライセンスがダウンロードできない。 弊社のアカウントが現在Microsoft M365と紐づいているが、過去のボリューム ライセンス サービス センター(VLSC) とは結び付いていない。
SQL Server Database Engine
536 questions
asked 2025-12-05T04:57:21.5133333+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(243.2, 94%, 33%)' 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)
しんどう
0
Reputation points
commented 2025-12-10T05:10:33.08+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
0 answers
SQL Server 2025 LocalDb installation is missing components
According to https://quic.hkg1.meaqua.org/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…
SQL Server Database Engine
536 questions
asked 2025-12-09T15:15:18.17+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(236.8, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Duncan Smart
0
Reputation points
commented 2025-12-09T22:41:41.6866667+00:00
Erland Sommarskog
128.9K
Reputation points MVP
Volunteer Moderator
1 answer
SQL License issue
We followed the guide available at: https://www.mssqltips.com/sqlservertip/7794/upgrade-sql-server-from-evaluation-edition-to-standard-or-enterprise/ However, when we tried to add the license key via the SQL Server Installation Center, we encountered…
SQL Server Database Engine
536 questions
asked 2025-11-20T02:36:44.1766667+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, 78%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Anson Lau
0
Reputation points
commented 2025-12-09T11:56:53.72+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator