14,715 questions
1 answer
Missing Columns in sys.dm_tran_persistent_version_store_stats in on-prem SQL Server 2025 and SQL Server 2022
I am unable to find the columns listed below (except database_id and database_name) in on-prem SQL Server 2025 and SQL Server 2022. What is the alternative way to retrieve this information, or are there equivalent columns/DMVs that should be used…
SQL Server | Other
asked 2026-03-26T13:43:23.3333333+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, 33%, 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)
ALAGARSAMY SUNDARARAJAN
0
Reputation points
answered 2026-03-26T13:44:02.2166667+00:00
Q&A Assist
2 answers
Act! V22: Windows 11 preventing installation of ACT! V22because of SQL and Shell issues. Help?
I have ACT! v22 which is on a Desktop and a Laptop. Both have Windows 11 and work fine. I just purchased a new laptop and I cannot get ACT! V22 to install. The error message is related to Windows 11 not allowing SQL 2014 and Shell 2 (I believe) to…
SQL Server | Other
14,715 questions
asked 2026-03-20T22:32:03.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(294.40000000000003, 85%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David Shear
0
Reputation points
commented 2026-03-26T11:44:41.17+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,075
Reputation points Microsoft External Staff
Moderator
1 answer
uninstall sql 2016 setup
we have done an in place upgrade of sql server from 2016 to 2022. However sql 2016 setup still shows in add remove programs and wont uninstall. How do i remove
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-22T20:57:47.9133333+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,496
Reputation points
commented 2026-03-26T11:43:00.13+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
SQL Server Course: 10987c - Performance Tuning and Optimizing SQL Databases
I need the Labs of mail subject course. Anyone can share please? Also, this course was retired by Microsoft, does anyone know the current alternative? please share material & Labs accordingly?
SQL Server | Other
14,715 questions
asked 2026-03-20T12:32:48.48+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(80, 94%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Amr Darwish
0
Reputation points
commented 2026-03-26T11:41:53.9866667+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
2 answers
Stored Procedure running longer hours
Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…
SQL Server | SQL Server Transact-SQL
278 questions
asked 2026-03-21T16:55:37.63+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-03-26T11:41:46.79+00:00
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
2 answers
Access to SQL
How can we request access for someone in our company to SQL Server Reporting Services?
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,147 questions
asked 2026-03-18T18:03:35.4933333+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, 14.000000000000002%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Janet Taglianetti
0
Reputation points
commented 2026-03-26T11:38:32.28+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
1 answer
How do we request access for someone in SSRS?
How do we request access for someone in SSRS to run reports?
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,147 questions
asked 2026-03-17T18:56:04.48+00:00
Janet Taglianetti
0
Reputation points
commented 2026-03-26T11:36:23.6266667+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
0 answers
SSRS Install Fails because Access Control List is not in Canonical Form
We are upgrading SQL server from 2016 to 2017, which means SSRS is now a separate installation. The OS is Windows Server 2019. We ran the 2017 version of SQLServerReportingServices.exe and the main installation log reports, "UnexpectedError: Burn…
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,147 questions
asked 2026-03-16T13:49:27.29+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, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL2%3C/text%3E%3C/svg%3E)
Loc750-2546
1
Reputation point
commented 2026-03-26T11:35:34.0566667+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
1 answer
Database replication alerts using the SMTP relay Port 25
We tested the TCP connection from the SQL Server to relay.****.com on port 25, and the connection was successful. However, the alert emails are still remaining in an unsent state. Do we need to configure basic authentication while using port 25?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-16T09:17:08.5333333+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, 68%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Devulacheruvu Venkatesh
0
Reputation points
commented 2026-03-26T11:34:12.8033333+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
2 answers
I can't install SQL SERVER 2025 EXPRESS
Hi. I am trying to install SQL SERVER 2025 EXPRESS in Basic mode . but it keeps failing and giving me this error code. I tried multiple things and finally decided to format my computer.Even that didn' work. Please, if you had this error and know how to…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-21T14:23:01.2433333+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, 26%, 21%)' 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)
Azra KARAAĞAÇ
0
Reputation points
commented 2026-03-26T11:33:52.8733333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
2 answers
Is sql copilot free or is a commercial option
When I clik on Copilot in SSMS it asks me for some input like endpoints, does this mean that it is not free? Thanks
SQL Server | Other
14,715 questions
asked 2026-03-14T12:49:39.1466667+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(64, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Salam ELIAS
257
Reputation points
commented 2026-03-26T11:33:33.1066667+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
2 answers
In place Upgrade from Sql 2014 to 2022
Hello, I am planning to perform Sql server 2014 to 2022 on Windows server 2022. I have done following before upgrade: Verified Sql server 2014 is at SP3 Done Assessment and nothing breaking change except depreciated datatype. We will be taking…
SQL Server | Other
14,715 questions
asked 2026-03-13T21:38:57.79+00:00
pdsqsql
436
Reputation points
commented 2026-03-26T11:32:56.22+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
1 answer
How to reset Local Database
My computer is saying local data base must be reset
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-13T14:59:56.87+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(211.20000000000002, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
StorTropolis - Tiffany Springs
0
Reputation points
commented 2026-03-26T11:31:52.1066667+00:00
Lakshmi Narayana Garikapati
1,075
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Licensing SSIS on a server used for deploying code via Visual Studio and SSIS to a SQL Server production server running on another server
See subject. Is it allowed to use Visual Studio on a management server used by a developer to deploy code via SSIS integration to a SQL server production environment that runs on a different server or will the management server be regarded as a part of…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,780 questions
asked 2026-03-19T08:33:18.6333333+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, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Leo van Mourik
20
Reputation points
commented 2026-03-26T07:50:26.2433333+00:00
Leo van Mourik
20
Reputation points
2 answers
Sequel server licensing
My distributer is telling me that SQL Server Standard 2022 - 2 Core License Pack - 3 yearSQL Server Standard 2022 - 2 Core License Pack - 3 year billed annually is a perpetual license? I have query with this as it has a termed subscription time?…
SQL Server | SQL Server Transact-SQL
278 questions
asked 2026-03-02T03:07:55.3166667+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, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Esther Cleave
0
Reputation points
commented 2026-03-26T06:42:57.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(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,570
Reputation points Microsoft External Staff
Moderator
1 answer
I have deleted this item and removed the registry entry, but the error persists.
SQL Server | Other
14,715 questions
asked 2026-03-01T13:22:19.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(60.8, 97%, 15%)' 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
commented 2026-03-26T06:28:30.1466667+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
1 answer
Status of Sql Server replication bug
Hi, A bit over a year ago, I reported a bug in Sql Server replication where columns using different collations than the db default were not replicated properly (in the specific case, the db default was SQL_Latin1_General_CP1_CI_AI and the columns being…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-25T19:01:38.7433333+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, 16%, 18%)' 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)
Modrall, Mark
15
Reputation points
answered 2026-03-25T19:01:51.34+00:00
Q&A Assist
1 answer
Upgrade from SQL Server 2022 Developer to SQL Server 2025 Standard Developer
Hello there, i have question about upgrade Scenario - Upgrade from SQL Server 2022 Developer Edition into SQL Server 2025 Standard Edition. In Documentation is mentioned this path is supported, but SQL Server 2025 Standard Developer Installer dont allow…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,780 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(252.8, 89%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
1 answer
Set up SQL server on server management studio
I'm on 4:57 of this video https://www.youtube.com/watch?v=Cr58jAj_YAc&t=10s I'm getting error like this. I look in the SQL server confirguation manager and apparently i have like 7 SQL server agents from downloading and reinstalling and the only…
SQL Server | Other
14,715 questions
asked 2026-03-07T17:41:57.12+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, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sam
0
Reputation points
commented 2026-03-25T11:04:20.1066667+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
Sql server 2025 standard version features
Which features we need to select while installing the sql standard 2025 for production environment,For 2019 and 2022 we select all client tools but here we have no clarity, so please suggest as soon as possible
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
673 questions
asked 2026-03-07T14:43:44.19+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-03-25T10:59:04.82+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator