14,672 questions
1 answer
SQL Server 2025 Standard Key not working for Power BI Report Server
I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…
SQL Server | Other
asked 2026-01-30T15:38:53.39+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(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kyle Minard
0
Reputation points
commented 2026-02-19T15:06:13.1066667+00:00
Kyle Minard
0
Reputation points
1 answer
One of the answers was accepted by the question author.
how to fix error 824 on sql 2022 server
SQL server detected a logical consistency-based I/O error: wrong checksum (expected 0x874dad05, found 0x556eaaf1). It occurred during a reading of page (4:215526) in database ID 7 at offset 0x000000693cc000 in file data.mdf. This is a severe condition…
SQL Server | Other
14,672 questions
asked 2026-02-19T14:34:23.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(246.4, 83%, 33%)' 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)
Luca Benedetto
20
Reputation points
accepted 2026-02-19T14:35:57.2633333+00:00
Luca Benedetto
20
Reputation points
1 answer
Error when loading mirrored Snowflake database using Key-pair Authentication: "The length 34 has exceeded the limit of 31."
I am using PowerBI services on Azure and a mirrored connection to Snowflake. I just switched to using Key-pair Authentication in PowerBI for the mirrored Snowflake database connection. Now, I get an error: "The length 34 has exceeded the limit of…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-19T13:56:35.4066667+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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anupam Singh
20
Reputation points
answered 2026-02-19T13:57:47.16+00:00
Q&A Assist
1 answer
Failed to retrieve content information. (0x87D30065) error while deploying the SQL2022-SSEI-Expr.exe through intune
Failed to retrieve content information. (0x87D30065) error while deploying the SQL2022-SSEI-Expr.exe through intune
SQL Server | Other
14,672 questions
asked 2026-02-19T10:23:09.05+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(144, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ram
0
Reputation points
edited the question 2026-02-19T11:27:26.1333333+00:00
Gérard Oomens
118.5K
Reputation points
Volunteer Moderator
1 answer
How to fix error received while inserting into table through report builder into oracle database
I am trying to insert records through report builder into oracle database and it is showing dataset related error
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-02-17T17:02:14.06+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(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' %3EMR%3C/text%3E%3C/svg%3E)
Madani, Ramya Krishna
0
Reputation points
answered 2026-02-19T10:58:15.49+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, 57.99999999999999%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Madani, Ramya Krishna
0
Reputation points
2 answers
could not activate sqlserver licence in windows server already perched new
hi my how to activate sqlserver standert in windows server .
SQL Server | Other
14,672 questions
asked 2026-02-15T07:02:10.7933333+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(83.2, 36%, 18%)' 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)
Mahbubul Alam
0
Reputation points
commented 2026-02-19T09:51:18.2266667+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, 10%, 23%)' 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)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
2 answers
inc microsoft sql server elevation of privilege vulnerability
(inc microsoft sql server elevation of privilege vulnerability) How to fix it why this vulnerabilities occurred, Latest patch applied on sql instance Recent saw this vulnerabilities on 2017,2019 and 2022 sql instances.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-14T12:18:00.0033333+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(201.6, 73%, 29%)' 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)
Anandhswarupp
205
Reputation points
commented 2026-02-19T09:50:29.1433333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
2 answers
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-15T23:44:37.3066667+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, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Greg Booth
1,436
Reputation points
commented 2026-02-19T09:33:53.48+00:00
Greg Booth
1,436
Reputation points
1 answer
SQL Server Agent not starting after installing KB5071544
My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…
SQL Server | Other
14,672 questions
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese
0
Reputation points
recommended 2026-02-19T09:02:11.37+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(256, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Valeria Putuntica (BLUEHAWK LLC)
0
Reputation points Microsoft External Staff
Moderator
0 answers
CDC change Data Capture on High availibility AlwaysOn 2019
Hello, I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-19T08:29:44.65+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, 80%, 38%)' 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)
Mona Seddik
20
Reputation points
answered 2026-02-19T08:29:56.36+00:00
Q&A Assist
1 answer
My SQL server exits after running for a few seconds in docker
Hi, I tried running MS SQL server in docker and it exiting withing a few seconds. I am running this on my MAC book. I want to connect Azure data studio to it. Can you please let me know a command that works. I have tried several options and nothing…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-17T17:21:11.53+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(198.4, 40%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LALITHA MARUTHACHALAM
0
Reputation points
edited a comment 2026-02-19T07:06:30.8233333+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(262.40000000000003, 96%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAY%3C/text%3E%3C/svg%3E)
Ankit Yadav
11,330
Reputation points Microsoft External Staff
Moderator
0 answers
Broken upgrade from SQL Server 2017 to 2022
Hello, SQL Upgrade was started at 2026-02-08 17:52:04. End time was logged as 2026-02-08 17:52:15 with final result "Pending". But in the Detail.txt file I see that last log entry is about 18:10. How can I recognize what is the reason of the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-02-17T15:19:23.0733333+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(144, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michał Lis
0
Reputation points
commented 2026-02-19T06:59:17.9433333+00:00
Michał Lis
0
Reputation points
3 answers
STAR Schema Model Design
Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 questions
asked 2026-01-28T02:53:43.0233333+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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
436
Reputation points
commented 2026-02-19T05:13:03.15+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
825
Reputation points Microsoft External Staff
Moderator
1 answer
I cannot download the software
It appears that the account you login to your computer with does not actually have full Administrator rights, which is a requirement for installation of the 4-CU and dependent software (SQL..., etc.). Contact your IT department so that they can: …
SQL Server | Other
14,672 questions
asked 2026-02-19T03:37:41+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, 35%, 26%)' 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)
Marlon King
0
Reputation points
edited the question 2026-02-19T04:56:35.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(19.2, 83%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michael Le (WICLOUD CORPORATION)
10,840
Reputation points Microsoft External Staff
Moderator
2 answers
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
640 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(294.40000000000003, 96%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
4 answers
One of the answers was accepted by the question author.
Syntax error in the statement
Hi, I wrote the following query and trying to figure out the syntax error: incorrect syntax near WHERE. DECLARE @SQL NVARCHAR(MAX) SET @SQL = (SELECT 'SELECT COUNT(*) FROM rv.' + table_name, +','+ QUOTENAME((table_name) + ' as table_name ' FROM…
SQL Server | SQL Server Transact-SQL
268 questions
asked 2026-02-17T18:25:30.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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,901
Reputation points
edited an answer 2026-02-18T23:33:50.67+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(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
27,096
Reputation points
2 answers
What is SQL error ID 8179 and how to fix it?
The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV. It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”). This issue often occurs when…
SQL Server | SQL Server Transact-SQL
268 questions
asked 2026-02-18T02:58:30.2366667+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(156.8, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Chirayu Traihirun
0
Reputation points
answered 2026-02-18T22:05:17.56+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
1 answer
server 2025 upgrade cause large files to fail during port forward
when files are port forward after the sever 2025 upgrade they fail Moved from Microsoft 365 and Office | Other
SQL Server | Other
14,672 questions
asked 2026-02-18T06:19:39.7766667+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(89.60000000000001, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Marcel Van Der Merwe
0
Reputation points
commented 2026-02-18T21:49:17.2333333+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
1 answer
optmization tecniques.
Wants to check query optimization tecniques.please guide SELECT FileName, FileDate FROM BROK.BROK_Staging ORDER BY FileDate DESC Join: https://teams.microsoft.com/meet/44686160893216?p=iDBacftSUDKBlVGWuf
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-02-18T09:58:35.11+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, 48%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Syntek S
0
Reputation points
commented 2026-02-18T21:46:24.23+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
An error was raised while trying to open the database
I am opening tickets with everyone since I am stuck on the attached error when opening compress.
SQL Server | Other
14,672 questions
asked 2026-02-18T18:52:39.0533333+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(99.2, 5%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Hoffman, Rhonda
0
Reputation points
recommended 2026-02-18T21:44:04.48+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator