SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
1 answer
GitHub Copilot in SSMS throws below error in Latest Version
GitHub Copilot in SSMS throws below error in Latest Version NOTE: Previous version it was working well An exception was encountered while constructing the content of this frame. This information is also logged in…
SQL Server | Other
asked 2026-07-02T09:07:12.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(32, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
Wazir Pattani Abdul Karim
0
Reputation points
commented 2026-07-02T12:02:04.15+00:00
Erland Sommarskog
135.3K
Reputation points MVP
Volunteer Moderator
2 answers
Distribution Cleanup Job Failing Silently in SQL Server 2019 Transactional Replication Causing Distribution DB Growth to 1.5 TB
Hello All, We are facing an issue with SQL Server Transactional Replication where the Distribution Cleanup job has been failing silently, and the distribution database has grown to approximately 1.5 TB, causing severe disk space issues. Environment SQL…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-05-16T08:14:26.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(252.8, 81%, 34%)' 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)
Parag Nimbhore
5
Reputation points
commented 2026-07-02T09:39:33.27+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, 44%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sowjanya Gopal
20
Reputation points
1 answer
Bulk deletes in Transaction Replication causing latency
Hi. I have around 10 publications on a database from Prod Server A to Reporting Server B. Created multiple publications so that any issue with one publication will not impact other publications. There is a single huge article in one publication. Due to…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-07-01T17:16:50.05+00:00
Sowjanya Gopal
20
Reputation points
answered 2026-07-01T17:17:16.3733333+00:00
AI answer
2 answers
One of the answers was accepted by the question author.
why do we need to update SSMS 22 everyday? Cant you provide a stable software which works for a month atleast without updates?
I have installed SSMS latest stable version and this software requires updates almost everyday. and Those does not work in the background but appears on screen and requires to close all my Queries which STOPs my current work everyday. Can Anyone tell me…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-28T08:55:01.36+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, 81%, 40%)' 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)
Ravindra Khadse
20
Reputation points
accepted 2026-07-01T06:09:52.3+00:00
Ravindra Khadse
20
Reputation points
2 answers
Best practices for monitoring Microsoft SQL Server performance
We are experiencing intermittent performance issues with our Microsoft SQL Server instance. At times, the system becomes very slow or completely unresponsive, and the only way to restore normal operation is to restart the server.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-24T10:47:19.1433333+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(118.4, 21%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nomeer Sheikh
0
Reputation points
commented 2026-07-01T05:42:59.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(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
1,335
Reputation points Microsoft External Staff
Moderator
0 answers
For backup stability and reliable recovery for running 2400 + DB , the memory issue needs to be addressed
Hi, For backup stability and reliable recovery for running 2400 + DB , the memory issue needs to be addressed. Can increasing physical memory in SQL Server help control or reduce SQL Server's memory footprint? Tomasz C.
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-29T11:37:10.9+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(268.8, 7.000000000000001%, 36%)' 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)
Ciolek, Tomasz
0
Reputation points
commented 2026-06-29T12:19:19.1233333+00:00
Erland Sommarskog
135.3K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Applications cannot login to moved db with Error: 18456 Severity: 14 State: 38 after AG failover
IaaS SQL Server on 2-node cluster with Always On Manual AG failover was successfull but applications can no longer connect. SQLServer logs report "Error: 18456 Severity: 14 State: 38" and "Login failed for user 'app_rh_sso'. Reason:…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-29T08:21:31.8566667+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(112.00000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andrea Floriddia
20
Reputation points
accepted 2026-06-29T08:42:41.01+00:00
Andrea Floriddia
20
Reputation points
5 answers
One of the answers was accepted by the question author.
Error importing excel file into SQL Server Management Studio 18
Good evening. And please I would appreciate any assistance I just installed my SQL Server 2019 and SQL Server Management Studio. I was able to connect to the server. However, I tried to import my excel data file from task option in the new data…
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,373 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2022-01-25T17:00:25.03+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(281.6, 50%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%3C/text%3E%3C/svg%3E)
Olagunju Oladayo
66
Reputation points
commented 2026-06-27T23:46:59.2466667+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, 28.999999999999996%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Divine
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Can't do a SQL edition upgrade after the trial install expired
I missed the install window for doing an edition upgrade with my real license and now I am in a catch 22: the SQL server will not start because the trial has expired and the edition upgrade fails because the trial has expired. I have tried installing a…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-24T20:23:09.5433333+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(60.8, 75%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jorge Abellas-Martin
20
Reputation points
commented 2026-06-26T19:30:41.8366667+00:00
Jorge Abellas-Martin
20
Reputation points
3 answers
MDS Excel Add-in: Data Loading Beyond Table Range in Specific Entity
Description: We are experiencing an issue with the MDS Add-in for Excel where data from a specific entity is not loading correctly for one of our users. Environment: SQL Server 2016 with Master Data Services MDS Add-in for Excel Entity contains…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2025-11-12T13:00:18.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(19.2, 96%, 11%)' 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)
Ronald Kraijesteijn
15
Reputation points
commented 2026-06-25T10:45:41.57+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(57.599999999999994, 59%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUJ%3C/text%3E%3C/svg%3E)
Ubeda, Jairo
0
Reputation points
2 answers
we can downgrade SQL server to which version? SQL Seever downgrade rights
we can downgrade SQL server to which version? SQL Seever downgrade rights, please share Microsoft link
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-24T13:02:47.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(201.6, 57.00000000000001%, 29%)' 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)
Mian Mudasir Bari
0
Reputation points
commented 2026-06-24T18:07:11.64+00:00
Erland Sommarskog
135.3K
Reputation points MVP
Volunteer Moderator
2 answers
maxdop of a query will fallback to serial or not.
if a query has maxdop 2 : in this case can microsoft decided in this situation to not to use parallelism and use all cores/or execute a query serially, as if parllelism is switched off
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-06T05:53:14.3433333+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
recommended 2026-06-24T16:34:05.4466667+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
1 answer
SQL vs NoSQL Databases: Key Differences and Use Cases
What is the difference between SQL and NoSQL databases, and when would you choose each?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-04T06:30:54.14+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(204.8, 98%, 29%)' 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)
Shafique Mulla
0
Reputation points
recommended 2026-06-24T16:31:36.7733333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Upgrading SQL 2019 to 2025 - Fulltext index issue
When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade. It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder,…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-03T07:09:59.9033333+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(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yunus Emre Coşkun
0
Reputation points
recommended 2026-06-19T06:19:46.21+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Power BI Desktop "Cannot establish connection" - msmdsrv.exe listening but connection timeout
Hello, I'm experiencing a persistent issue with Power BI Desktop failing to start. The error message is: "Cannot establish connection. Please verify that the server is running." Environment OS: Windows 11 Pro (10.0.26200) Hardware: Intel…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-02T13:27:29.3566667+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, 62%, 39%)' 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
recommended 2026-06-19T06:19:10.57+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Migration feature on SSMS 22
Hi Expert, I'm running first time Migrate SQL Server feature on SSMS 22 for Database Assessment with 10TB size, this report as below: "Status": "Error", "**AssessmentRecommendations": [],** "Name":…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-05-25T02:27:55.1566667+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, 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)
Urbel
665
Reputation points
recommended 2026-06-19T05:51:41.11+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
The error was while running the store procedure runs xp_cmdshell to run a batch file
The stored procedure SP_CreateClientDatabase internally uses xp_cmdshell to execute a batch file located at: F:\ECLOUD_DB_Script\CreateDB.bat However, the execution is currently failing with the below error:An error occurred during the execution of…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-05-13T05:50:36.9933333+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(307.2, 54%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeyamani Sekar
20
Reputation points
recommended 2026-06-19T05:50:47.03+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL “untrusted domain” error over VPN for one device only (Windows Auth)
I’m looking for some advice on an issue affecting a single user/device when connecting to SQL Server over VPN. The user receives the following error when launching an application that connects to SQL Server using Windows Authentication: “Login failed.…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-04-21T15:43:08.6733333+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, 21%, 16%)' 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)
Lee Barnes
0
Reputation points
recommended 2026-06-19T05:46:21.56+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Reinstallation doubt regarding Microsoft Visual C++ 2017 distributable package error
can we resolve this SQL Server 2019 install warning - Microsoft Visual C++ 2017 distributable package error, by re-installing the Microsoft Visual C++ 2017 distributable package, if the current windows version already got end of support?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-06-15T06:01:27.0666667+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(185.6, 71%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jainil Panchal
0
Reputation points
edited a comment 2026-06-18T09:23:59.5866667+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,830
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,759 questions
asked 2026-04-29T12:20:04.25+00:00
Parag Nimbhore
5
Reputation points
commented 2026-06-18T05:41:59.27+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator