21,790 questions with SQL Server-related tags

Sort by: Updated
2 answers

Error 8624, Severity 16: Internal Query Processor Error: The query processor could not produce a query plan.

Hi, Environrment : SQL Server 2022, build 16.0.4252.3 (CU24 + GDR, May 2026) We are experiencing an intermittent issue on Microsoft SQL Server 2022 Enterprise Edition running in an Always On Availability Group environment.A specific stored procedure…

SQL Server Database Engine
asked 2026-07-05T10:07:13.09+00:00
Mohanraj Selvarasu 20 Reputation points
recommended 2026-09-24T21:15:22.6566667+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
5 answers

Source files within source systems are not synchronized with raw tables in Azure database

Hello, I would like to ask for suggestions regarding the following problem: Our DWH architecture was initially configured in the way, that source files from various source systems should be aligned with actual raw tables in our Azure database [we…

SQL Server Database Engine
asked 2026-09-04T12:44:56.3166667+00:00
recommended 2026-09-24T21:13:41.57+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
3 answers

How to enable Microsoft Entra authentication for SQL Server 2025 Express enabled by Azure Arc?

Environment Windows Server 2025 Standard SQL Server 2025 Express 17.0.1135.8 Azure Arc enabled server Azure SQL Extension version 1.1.3518.465 Region: Germany West Central Background The server was originally onboarded in Poland Central, where…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2026-09-23T11:54:37.2466667+00:00
Folttiny František 0 Reputation points
recommended 2026-09-24T20:43:17.0866667+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
2 answers

How to restore SQL database in a VM.

We are planning to restore the SQL database in a VM. To a target VM. After restoring the source VM from the latest available snapshot. Please provide the procedure to restore the SQL database , to the target VM. King Regards, Harish Nagaraja

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2023-07-17T17:03:52.5666667+00:00
Harish Nagaraja 5 Reputation points
edited a comment 2026-09-24T11:32:33.09+00:00
Monika Dadool 0 Reputation points
0 answers

Cube failure due to data length issue

Cube failure with below error “Errors in the OLAP storage engine: An error occurred while the 'Diagnosis' attribute of the 'DimUniqueDiagnosis' dimension from the 'CQMC_RBGBGWS_Analysis_Test' database was being processed.” We are doing SL3 to SL4 server…

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

1,379 questions
asked 2026-09-24T10:17:43.5566667+00:00
Kayal 0 Reputation points
1 answer

SQL Server 2025 PBKDF2 login performance regression with Microsoft Access/ACE – supported mitigation?

We have reproduced a significant SQL Authentication performance regression after migrating an on-premises Microsoft Access application from SQL Server 2022 to SQL Server 2025. Environment SQL Server 2025 Express CU9, 17.0.5005.3 Windows Server 2022 …

SQL Server Database Engine
asked 2026-09-23T21:01:52.2466667+00:00
devswick 0 Reputation points
commented 2026-09-24T08:15:02.26+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
0 answers

How to Export Text file without CRLF on very last data record

I have a data-driven subscription that writes a text file to a shared file area. Everything is fine. However, I added custom code in VB to see if I could strip the very last CRLF at the end of the file (EOF). The report ran, but it didn't remove CRLF. I…

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

3,183 questions
asked 2026-09-24T00:59:05.8833333+00:00
Corey Fleig 530 Reputation points
edited the question 2026-09-24T01:00:05.13+00:00
Corey Fleig 530 Reputation points
5 answers

Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True

Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…

SQL Server Database Engine
asked 2026-07-13T09:22:07.6666667+00:00
Abhishek Modi (amodi) 20 Reputation points
answered 2026-09-23T14:42:16.5033333+00:00
Bruce (SqlWork.com) 85,456 Reputation points
3 answers One of the answers was accepted by the question author.

missing login ##MS_PolicyEventProcessingLogin## and ##MS_PolicyTsqlExecutionLogin##

hi Folks, On one of our sql server we are seeing missing logins ##MS_PolicyEventProcessingLogin## ##MS_PolicyTsqlExecutionLogin##. due to which we are getting error like "The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2024-02-21T20:10:54.98+00:00
Heisenberg 266 Reputation points
commented 2026-09-23T14:39:26.23+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
1 answer

What AES mode does TDE use in on-premises SQL Server?

We are certifying a software product that uses Microsoft SQL Server as its database engine. The certification body has asked us to identify the AES mode of operation used by Transparent Data Encryption (TDE) when SQL Server is deployed on-premises. The…

SQL Server Database Engine
asked 2026-09-23T09:47:15.7866667+00:00
Raúl Porras Martín 0 Reputation points
edited a comment 2026-09-23T14:39:15.0866667+00:00
Marcin Policht 109.1K Reputation points MVP Volunteer Moderator
4 answers

Need to delete Millions of records from table which is part of Transaction Replication

I have transaction replication on a table. I have to delete millions of records from it. I want to create a SP to delete rows & replicate execution of SP. A few records mismatch might be there between Publisher & Subscriber. Will it cause issue.…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2026-09-21T19:27:54.4666667+00:00
Sowjanya Gopal 100 Reputation points
answered 2026-09-22T18:03:19.8466667+00:00
Deepesh Dhake 1,165 Reputation points
0 answers

Need original microsoft hecksum value for latest Microsoft Command Line Utilities for SQL Server before downloading

Hi, I need to download the latest version of Microsoft Command Line Utilities x64 for SQL Server for Windows OS. I can see it is available here: https://learn.microsoft.com/en-us/sql/tools/bcp/bcp-download-install?view=sql-server-ver17 Before installing…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2026-09-22T12:47:14.6166667+00:00
GVC 10 Reputation points
2 answers

Shrinking the size of a volume on a SQL Server

Hello. We need to shrink the size of a Windows volume from its current sixty-five, 65, terabytes to sixty, 60, terabytes. The reason for this move is due to the Microsoft Volume Shadow Service, VSS, having an operational limit of sixty-four, 64,…

SQL Server
SQL Server

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

6 questions
asked 2026-09-22T12:19:38.7166667+00:00
Kaplan, Andrew H 226 Reputation points
answered 2026-09-22T12:33:28.08+00:00
Marcin Policht 109.1K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

model_replicatedmaster.ldf move to another drive

Hi all, I'm curios about this 2 new DB (system). I'm moving all ".ldf" file to a single drive... but they are related (seems to me) to HA. I read this post …

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2022-05-17T14:28:30.69+00:00
Alen Cappelletti 1,047 Reputation points
commented 2026-09-22T10:32:41.55+00:00
Russell Bride 0 Reputation points
2 answers

Master Data Services web app renders empty after SQL Server CU26 update

Hi everyone, SQL Server 2022 CU26 appears to break Master Data Services web application. After patching to CU26 (16.0.4265.3), the MDS web application loads, but is completely empty. The MDS database and data remain intact and are visible through SQL…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2026-09-03T11:43:17.93+00:00
Simon Lenk 5 Reputation points
commented 2026-09-21T11:04:14.78+00:00
Henrik Munch 0 Reputation points
0 answers

SQL Server: Unexpected CPU Spike on Primary Replica — Troubleshooting Assistance Needed

Problem description I am experiencing an issue with my SQL Server virtual machine where the primary replica of an Always On availability group in the UK South region is experiencing unexpected CPU utilization spikes up to 100%. This occurs under a…

SQL Server Database Engine
asked 2026-09-05T12:21:24.7233333+00:00
Prakash Nandwana 0 Reputation points
commented 2026-09-20T15:38:14.7066667+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
2 answers

I'm trying to install sql server 2019 and it doesn't install .

it gives me this error when i press install

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,810 questions
asked 2026-09-19T21:55:42.81+00:00
Juanpa 0 Reputation points
commented 2026-09-20T10:14:12.8133333+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
1 answer

KB5126149 cause SnowFlakeID broken in MS SQL Server

Below windows update package caused SnowFlakeID broken in MS SQL SERVER, this issue is very serious, caused all transactions cannot record, below are the KB and mapping windows version: OS .NET Update KB Vulnerabilities Addressed Win11 24H2 / 25H2…

SQL Server | SQL Server Transact-SQL
asked 2026-09-18T08:22:44.49+00:00
Water Yue 0 Reputation points
commented 2026-09-20T09:57:36.4766667+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
1 answer

Log shipping backups

Good Morning Can we take full backup of primary database and full backup of secondary database in Log Shipping?

SQL Server Database Engine
asked 2026-09-19T06:14:16.33+00:00
Chaitanya Kiran 841 Reputation points
answered 2026-09-19T19:49:03.0733333+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
1 answer

Support for Entra User Identity Passthrough to Remote MCP (SQL MCP Server) in Azure AI Foundry (Prompt Agent vs. Hosted Agent)

Azure AI Foundry: Entra User Identity Passthrough to Remote MCP (Prompt Agent vs. Hosted Agent) Hello Microsoft Community, I'm trying to determine whether Azure AI Foundry supports end-user identity passthrough when invoking a Remote MCP Server (SQL…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,805 questions
asked 2026-09-08T07:50:13.63+00:00
Herman Tsago 0 Reputation points
answered 2026-09-19T15:13:57.78+00:00
Walker Pollitt 0 Reputation points