21,355 questions with SQL Server-related tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Critical: SQL Server 2019 CU32 Crash – c0000005 Access Violation (sqldk.dll) – Production Impact

Dear Microsoft Support Team,We are experiencing repeated unexpected shutdowns of our production SQL Server instance and would like to raise a critical support ticket for investigation.Environment Details: Product: Microsoft SQL Server 2019 Enterprise…

SQL Server Database Engine
asked 2026-02-25T07:07:51.5366667+00:00
vivek singh 20 Reputation points
accepted 2026-02-25T07:27:48.98+00:00
vivek singh 20 Reputation points
1 answer

Assessment for SSISDB and SSIS Catalogue

Hi all, I'm using tools Migrate SQL server to migration assessment at SSMS v22, but SSISDB database did not appear in Database selection something's wrong at my SSMS ? thanks for all reply regards, Urbel

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
603 questions
asked 2026-02-25T06:50:22.2766667+00:00
Urbel 400 Reputation points
answered 2026-02-25T06:51:01.24+00:00
Q&A Assist
1 answer

SSIS Package Development in Windows on ARM (MacOS running Parallel)

Hi, Based on https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver17&tabs=vs2026#visual-studio-for-arm64 Although was not able to find SSIS Extension within Visual Studio (2026) but was able to complete…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
asked 2026-02-18T01:32:46.5933333+00:00
Tommy Teoh 0 Reputation points
edited a comment 2026-02-25T06:43:26.3866667+00:00
Lakshmi Narayana Garikapati 920 Reputation points Microsoft External Staff Moderator
1 answer

Failed Silently when SSMS v22 layout offline installation

Hi expert.. I apply as MS Documentation at https://learn.microsoft.com/en-us/ssms/install/create-offline but it still failed silently, at above document it related to created Certificate but it still didnt worked.. any experience of this issue? thanks…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
603 questions
asked 2026-02-25T03:10:38.7033333+00:00
Urbel 400 Reputation points
answered 2026-02-25T03:10:49.9033333+00:00
Q&A Assist
0 answers

cannot open or create sql agent alerts

When I try opening an existing alert in SSMS (SQL Agent - Alerts) or create a new alert, I receive the following error: The Show details button contains the following: =================================== Cannot show requested…

SQL Server | Other
asked 2026-02-24T22:02:13.37+00:00
Charles Burschtin 0 Reputation points
commented 2026-02-24T23:20:01.01+00:00
Charles Burschtin 0 Reputation points
2 answers One of the answers was accepted by the question author.

STIntersection() hangs forever

Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…

SQL Server Database Engine
asked 2026-02-18T18:14:47.0433333+00:00
MarkusW 20 Reputation points
accepted 2026-02-24T23:17:52.4866667+00:00
MarkusW 20 Reputation points
2 answers One of the answers was accepted by the question author.

how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022

We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…

SQL Server Database Engine
asked 2026-02-15T23:44:37.3066667+00:00
Greg Booth 1,456 Reputation points
commented 2026-02-24T23:13:56.88+00:00
Greg Booth 1,456 Reputation points
1 answer

Migrating Large Size scale Database

Hi all, what is alternative method to migrating side by side large size Database thanks for all reply regards, Urbel

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
603 questions
asked 2026-02-24T02:50:57.9666667+00:00
Urbel 400 Reputation points
commented 2026-02-24T22:25:21.02+00:00
Erland Sommarskog 132.6K Reputation points MVP Volunteer Moderator
1 answer

Enabling RCSI and ADR on SSISDB and ReportServer

We're considering enabling two database-level settings on SSISDB and ReportServer: READ_COMMITTED_SNAPSHOT (is_read_committed_snapshot_on = 1) — reduces blocking by using row versioning instead of shared locks ACCELERATED_DATABASE_RECOVERY…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
asked 2026-02-24T22:16:48.07+00:00
Louis Davidson 21 Reputation points
answered 2026-02-24T22:16:58.03+00:00
Q&A Assist
2 answers

How does one go about buying a SQL license?

I know this sounds like it should be simple, but it's not. The marketplace goes nowhere, call MS, they don't call back. I assume I need to find a licensed partner, but that is also no response. Can anybody point me to somebody that I can give money to…

SQL Server | Other
asked 2026-02-24T15:24:35.8666667+00:00
Jim 386 Reputation points
answered 2026-02-24T22:14:19.5233333+00:00
Erland Sommarskog 132.6K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to create initial full backup followed by transaction logs daily?

This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…

SQL Server | SQL Server Transact-SQL
asked 2026-01-30T18:06:58.63+00:00
Justin Doh 980 Reputation points
commented 2026-02-24T22:05:46.54+00:00
Erland Sommarskog 132.6K Reputation points MVP Volunteer Moderator
0 answers

SQL Server Developer Edition Installer can't identify an installed software it needs.

Hi! I'm having a problem installing Microsoft SQL Server Developer Edition. It says that a certain software is not installed, although it is indeed installed. Any idea how can I solve this issue? The following lines are copied from Details.txt…

SQL Server Database Engine
asked 2026-02-21T13:32:24.1533333+00:00
Abdelrahman Hany 0 Reputation points
commented 2026-02-24T22:04:32.5733333+00:00
Erland Sommarskog 132.6K Reputation points MVP Volunteer Moderator
2 answers

SQL Server 2025 Standard License

I have downloaded SQL server 2025 Standard iso from volume licensing portal and when trying to install it gives predefined license key in the setup but we also have key available in licensing portal which is different than the one embedded in the setup…

SQL Server | Other
asked 2026-02-14T15:56:35.87+00:00
Shivank Gupta 0 Reputation points
commented 2026-02-24T21:52:56.39+00:00
Erland Sommarskog 132.6K Reputation points MVP Volunteer Moderator
1 answer

Facing issue with SQL Server CDC

Hi Team, I am working on Change Data Capture feature in SQL Server (on premises). In the Database in which Change Data capture feature is enabled, I am having a table MQ which gets filled with a CT table, having a SQL function which selects data from…

SQL Server Database Engine
asked 2025-09-13T17:06:49.8166667+00:00
Salil Singh 60 Reputation points
recommended 2026-02-24T18:38:43.6933333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

How can I recover my purchased Microsoft SQL 2019 license?

Good morning, I purchased a Microsoft SQL Server license on August 20, 2021. Authorization number: [Moderator note: personal info removed] License number: [Moderator note: personal info removed] I need to reinstall the server using the license with its…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
603 questions
asked 2025-10-20T12:51:48.9533333+00:00
Marco Caroli 0 Reputation points
recommended 2026-02-24T18:38:12.9733333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Getting an error installing SQL Server 2022 in my computer

I'm getting error when installing SQL server 2022. I'm attaching the summary and details log here.Detail.txt

SQL Server Database Engine
asked 2025-10-21T08:02:58.63+00:00
Anthony 0 Reputation points
recommended 2026-02-24T18:37:41.4533333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

Issues with SSRS Configuration Manager reports

Hi, we have been struggling with this for a while now (we needed to change Configuration Manager SSRS service account password and then this started): 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.…

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,141 questions
asked 2026-01-24T14:25:14.3066667+00:00
Bojan Zivkovic 616 Reputation points
recommended 2026-02-24T18:37:12.2766667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

How to install my SQL Server Express 2025

Hi, I have issues regarding the SQL Server 2025 Express and I got this error/trouble-shooting message popped up this display. Can you help me process this step by step how to resolve this? I'm using Windows 11 (I think) in this case. Thank you.

SQL Server | Other
asked 2026-01-29T05:19:45.14+00:00
Michael Le 0 Reputation points
recommended 2026-02-24T18:36:53.35+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL volume license not available

SQL server license was purchased through our reseller. Volume license is still not visible on my admin account

SQL Server Database Engine
asked 2026-01-29T03:51:41.4333333+00:00
Lynda Lawrence 0 Reputation points
recommended 2026-02-24T18:36:32.1033333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering

We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…

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,141 questions
asked 2025-07-08T12:42:00.13+00:00
Máté Gribovszki 0 Reputation points
recommended 2026-02-24T18:36:05.9433333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator