SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
0 answers
Databasemail stops working on SQL Server 2025 after CU1 install
We have server with SQL Server 2025 RTM that works fine but when we install CU1 for SQL Server 2025 the databasemail stops sending mail from SQL Server, nor error message no mail reach mailbox. SQL Server version 17.0.4005.7
SQL Server Database Engine
asked 2026-01-20T18:20:29.8566667+00:00
Micael Carlsson
1
Reputation point
commented 2026-01-20T19:15:56.9833333+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, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jure Kranjc
0
Reputation points
3 answers
DatabaseMail.exe fails after SQL Server 2022 from CU22 to CU23 - Missing Microsoft.SqlServer.DatabaseMail.XEvents.dll
Product: SQL Server 2022 Enterprise Edition Affected Versions: CU23 Component: Database Mail Summary: Database Mail fails to start or send emails after updating to SQL Server 2022 CU23 (also observed on CU22) with error indicating missing assembly…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T07:29:32.3466667+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(140.8, 28.000000000000004%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Musa YILMAZ
30
Reputation points
commented 2026-01-20T18:56:48.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(102.4, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cristian Rojas Lillo
0
Reputation points
2 answers
How to delete this database?
In order to conduct the test, the 'testdb' database was created, after a series of operations, the size of the data file is 1G and the size of the log file is 0.5M. No application other than SSMS accesses it. Currently, sys.databases.state_desc =…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 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, 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)
1 answer
MySQL INSERT fails with ERROR 1064, 1265, 1292 (invisible character in numeric ID, ENUM mismatch, invalid DATETIME)
Hi, I’m importing seed data into a MySQL table and my bulk INSERT fails with multiple errors depending on the row. I suspect some data-cleaning/format issues during copy/paste or CSV → SQL conversion. Table definition CREATE TABLE lead_broker_status ( …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-02T12:42:04.7466667+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(316.8, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Arthur Tong
0
Reputation points
edited a comment 2026-01-20T11:03:38.9733333+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
1,125
Reputation points Microsoft External Staff
Moderator
2 answers
"Is it okay to run Ola Hallengren’s index rebuild and stats update script from a separate database instead of master, and will this impact fragmentation handling?"
In my organisation, we run Ola Hallengren’s index rebuild and update stats script on a separate database instead of the master database. Is this a recommended practice, and will it affect index fragmentation or reorganisation?"
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 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(102.4, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
1 answer
failed to collect frames
continuous sql error logs in secondary read replica always on node, failed to collect frames
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T16:51:40.7966667+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, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Bhavana Yadav
0
Reputation points
commented 2026-01-20T09:14:17.63+00:00
Bhavana Yadav
0
Reputation points
1 answer
Connectivity Issue Between SQL Server Databases and Windows Failover Cluster
image1.png.pdf We are currently experiencing connectivity issues between the Active/Active SQL Server databases and the Windows Failover Cluster. As a result, the cluster is not functioning properly, and all load is currently running on a single…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-10-06T14:31:39.9866667+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(275.2, 51%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mir Majeed
20
Reputation points
recommended 2026-01-20T05:02:54.6933333+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Vector Indexes
I have a database table with a Vector Column in SQL Server 2025 but unable to use the Create Vector Index Command
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T02:16:48.04+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(48, 0%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Bradley Jones
0
Reputation points
answered 2026-01-19T22:19:02.7766667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
2 answers
vs_SSMS installation - Destination URLs
Dear all, I'm installing vs_SSMS (SQL Server Management Studio) on a client's server. I requested them to open internet connection to be able to install SSMS as i know that the installation once it runs, will download the required files. The client's IT…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-13T12:48:10.6633333+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(300.8, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alaa Al Halabi
0
Reputation points
commented 2026-01-19T21:51:41.4166667+00:00
Erland Sommarskog
131.1K
Reputation points MVP
Volunteer Moderator
1 answer
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 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
recommended 2026-01-19T18:01:37.7266667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
SQL Server installation fails with error 0x851A001A after removing old instances
Hi, I’m unable to install SQL Server 2025 Express or 2019 Express. The setup fails every time with: Error: Wait on the Database Engine recovery handle failed Exit code: -2061893606 (0x851A001A) Component: SQL Server Database Engine Services The setup…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-12-01T13:58:58.7866667+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(147.20000000000002, 74%, 24%)' 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)
Ailin
0
Reputation points
recommended 2026-01-19T17:52:06.4166667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
DB STARTUP events in AG replica SQL error log
HI Team, we got an Availability group with 4 nodes (1 primary, 2 synch nodes, 1 asynch node). in the secondary replica sql error logs I see frequent messages as below for various secondary databases. Example: Buffer Pool scan took 11 seconds: database…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-11-16T22:59:43.8533333+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, 85%, 32%)' 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)
subhash-DBA
155
Reputation points
recommended 2026-01-19T17:43:13.36+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server 2025 Installation Error
SQL Server 2025 Enterprise Developer Edition Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-12-19T13:15:23.24+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(54.400000000000006, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vijoy T Abraham
0
Reputation points
recommended 2026-01-19T17:28:03.9866667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 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
recommended 2026-01-19T12:29:26.1633333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
4 answers
Can't install Microsoft® SQL Server® 2016 Service Pack 2 Express
Hi, I'm unable to install Microsoft® SQL Server® 2016 Service Pack 2 Express on Windows server 2019 : Can anyone help me ? Thanks. Corine
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-11-06T12:39:37.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(310.4, 28.000000000000004%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
CORINE MARCON
0
Reputation points
recommended 2026-01-19T12:25:51.46+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Best-practice design for multi-site SQL Server Always On AG (two cities, on-prem)
Hello, I would like your guidance on a multi-site SQL Server Always On Availability Group design across two on-premises locations. Environment: Two on-prem data centers in different cities (City A and City B) SQL Server 2022 Enterprise Edition Windows…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-11-11T15:02:44.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(9.6, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Srag Zahran
0
Reputation points
recommended 2026-01-19T12:25:23.6233333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Exporting database DDL using sqlpackage.exe has different result vs SSMS create table script
Hi guys, I'm trying to export all the DDL of my DB into a single .sql file to do some documentation auto-composition tests with AI. I noticed that the command I use as &"C:\Program Files\Microsoft SQL Server\170\DAC\bin\sqlpackage.exe"…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-10-29T14:16:22.43+00:00
Alen Cappelletti
1,047
Reputation points
recommended 2026-01-19T12:22:32.61+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
I have installed SSMS 2022 but unable to login.
Hello Team, I have installed SSMS 2022 on my local laptop. But I am unable to connect to the connection string. My laptop server name is ASHISH and instance name is MSSQLSERVER. I am entering ASHISH\MSSQLSERVER as Server Name but it is showing error code…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2026-01-19T09:20:08.8366667+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(102.4, 89%, 19%)' 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)
Ashish Karnavat
0
Reputation points
edited an answer 2026-01-19T12:22:25.86+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
670
Reputation points Microsoft External Staff
Moderator
1 answer
How can I get the email used to buy a sqlserver license
I have a SQL Server 2017 license, but I can't find the email address it was purchased with. I don't think it's tied to a tenant, but it could be tied to another account, but I can't figure out which one. Isn't there a form where I can enter the license…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-10-24T13:48:47.1+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, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Meteo Solutions
0
Reputation points
recommended 2026-01-19T12:21:33.0966667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Why does SQL Server throw Error 701 after enabling Lock Pages in Memory (LPIM)?
I have a SQL Server instance with 64 GB physical RAM. LPIM is enabled. max server memory is set to 58 GB. After LPIM is enabled , started seeing below errors which I didn't expect . Error: 701, Severity: 17, State: 123. There is insufficient system…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
585 questions
asked 2025-11-23T15:02:15.89+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(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
230
Reputation points
recommended 2026-01-19T12:19:39.87+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator