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,120 questions
1 answer
Is there any better disaster recovery than Transactional Replication?
I am trying to implement Transactional replication on SQL Server 2016 from Prod server to Report server. But it is not carried lot of tables that doesn't have Primary keys and those tables are important too. Is there different disaster recovery tools…
SQL Server Reporting Services
asked 2025-12-10T19:28:35.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(83.2, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jinal Contractor
121
Reputation points
answered 2025-12-10T19:28:55.6+00:00
Q&A Assist
1 answer
Select most recent data per record from multiple tables
I am trying to get the latest data for a record from multiple tables. The issue I am running into is that the data on each table could have been modified at different times and each table may contain multiple rows per record. I am currently using row…
SQL Server | SQL Server Transact-SQL
254 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(265.6, 6%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
2 answers
SQL Server maintenance plans not running
None of my maintenance plans are running. They are Enabled as Recurring and scheduled to run daily or weekly, but when I select each plan and View History, they are not even attempting to run. The only History they have are the runs that I manually…
SQL Server | Other
14,617 questions
asked 2022-11-17T17:47:14.533+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(288, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Scott Fischer
1
Reputation point
commented 2025-12-10T16:03:52.55+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, 54%, 21%)' 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)
Jacob Pitsch
0
Reputation points
2 answers
Descrepancy between SalesLT.SalesOrderDetail and SalesLT.SalesOrderHeader?
I deployed a new AdventureWorks LT. When I query: select * from SalesLT.SalesOrderDetail where salesorderID = 71774 there's 2 rows: SalesOrderDetailID's 110562 and 110563. They both have a linetotal of 356.898000 so when I query: select sum(LineTotal)…
SQL Server | SQL Server Transact-SQL
254 questions
asked 2025-12-10T14:31:19.0566667+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, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jasper Versteegh
0
Reputation points
answered 2025-12-10T15:00:54.3933333+00:00
Jasper Versteegh
0
Reputation points
1 answer
SSMS 20.2 Import Wizard Throwing Error at Server End
I was trying to use the import wizard in SSMS and found that the destination servers was throwing the above error. The error that the server administrator has sent me is: "The EXECUTE permission was denied on the object…
SQL Server | Other
14,617 questions
asked 2025-12-10T14:34:02.6566667+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, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Richard Williams
15
Reputation points
answered 2025-12-10T14:34:17.27+00:00
Q&A Assist
0 answers
Azure SQL Database Hyperscale Serverless
I have a database in Azure. It's an SQL Database that runs only one process per day, just one in 24 hours. When this process runs, it consumes a lot of DTUs and CPU, requiring approximately 4 to 6 vcores. Therefore, I configured this database with a…
SQL Server Database Engine
535 questions
asked 2025-12-10T12:50:29.5466667+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, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
325
Reputation points
asked 2025-12-10T12:50:29.5466667+00:00
Fernando Gutierrez
325
Reputation points
1 answer
HOW TO FIX SQL SERVER(Local Instance MYSQL80)
MY SQL SERVER IS NOT RUNNING AND IT IS NOT CONNECED
SQL Server Database Engine
535 questions
asked 2025-12-03T07:13:45.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(137.6, 24%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
Isha Jangid
0
Reputation points
commented 2025-12-10T11:58:35.86+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(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.
hi, hi, i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT…
SQL Server Database Engine
535 questions
asked 2025-12-10T10:50:27.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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
291
Reputation points
commented 2025-12-10T11:32:53.88+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
650
Reputation points Microsoft External Staff
Moderator
2 answers
how fix the error that occurs when I try to install SQL Server 2019
The following is the error message that I keep getting each time I tried to install SQL Server 2019: Unable to install SQL server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check…
SQL Server Database Engine
535 questions
asked 2025-12-02T13:56:13.8866667+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(44.800000000000004, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
CJAY Nwadinobi
0
Reputation points
commented 2025-12-10T10:46:45.8833333+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
3 answers
License Verification for SQL Server Express Commercial Use on AWS EC2
We are planning to install SQL Server Express Edition on an AWS EC2 instance running Windows Server and use it for commercial purposes. We would like to confirm whether this usage complies with the licensing terms. Environment details: Cloud platform:…
SQL Server | Other
14,617 questions
asked 2025-11-26T08:24:28.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(137.6, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Seiji Yoshida (吉田 誠司)
0
Reputation points
commented 2025-12-10T10:40:10.3966667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
1 answer
SQL 2022 SSIS with ACE 12 32bit error unexpected Termination
Hi We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit. We had to upgrade our servers to Windows 2022 SQL 2022 we installed ACE 16 32bit but when running the SSIS…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
asked 2025-09-14T08:49:48.7566667+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, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Katayoun Sarab
0
Reputation points
answered 2025-12-10T09:57:44.7233333+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
0 answers
How can I get my Server and SQL authorization back?
I can provide the authorization number and usage right number. How can I retrieve the product registration account and authorization?
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.
586 questions
asked 2025-12-01T09:37:18.8166667+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(182.40000000000003, 90%, 27%)' 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
edited a comment 2025-12-10T09:53:28.4266667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
REQUEST FOR SQL DATABASE
I am currently on the get data module on power bi, I have been learning how to import data and then I have gotten to SQL relational database. for better understanding it would be good to have a SQL database to practices with. Is it possible to download…
SQL Server | Other
14,617 questions
asked 2025-12-01T08:51:10.78+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(73.60000000000001, 21%, 17%)' 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)
osatohanmwen odia
0
Reputation points
commented 2025-12-10T09:01:23.09+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
I can't connect to the Analytical services when using the SSMS
Hello , I can't connect to the analytical services using SSMS , it's shown as a disabled select option I have already added the SSAS feature to the exisiting installation and It is already existant in services (msc) What can I do to enable the…
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,365 questions
asked 2025-11-27T15:34:10.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(220.8, 21%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
oussema_guerriche
0
Reputation points
commented 2025-12-10T08:50:03.43+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
3 answers
Setting Up Microsoft SQL Server on New Device
Hello, I recently set up MS SQL Server on a new computer. On my old machine, the server name was OLDCOMPUTER#\SQLEXPRESS and it used Windows Authentication with the username OLDCOMPUTER#\atsuser. On the new computer, the username is based on the new…
SQL Server Database Engine
535 questions
asked 2025-11-25T20:52:04.0366667+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(176, 37%, 27%)' 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)
Dana Slepyan
0
Reputation points
commented 2025-12-10T07:57:17.6866667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
Following an upgrade KPI tiles have disappeared
Has anyone else had this issue version SQL2019 migrated to SQL2022
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,120 questions
asked 2025-11-19T15:41:14.75+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, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Richardson Carolyn - Birkenhead-UK-ITSSO
0
Reputation points
commented 2025-12-10T07:53:41.0133333+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
BROOOOO I am trying to install sql server 2022 version but its saying fare wall warning no matter how many help i saw i couldnt just figure out the problem please help me
Bruhhhh Why cant i find the goddamn problem! i been trying to install the sql server but everytime i am stuck at Install Rules where there is a Windows farewell warning!!! Eventough i install it anyways i have a problem at Installation process where it…
SQL Server Database Engine
535 questions
asked 2025-11-20T17:48:38.0933333+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, 0%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sanjana velicheti
0
Reputation points
commented 2025-12-10T07:45:29.76+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
What happens to my account when the Volume Licensing Service Center (VLSC) is replaced by the Microsoft M365 Admin Center?
ボリューム ライセンス サービス センター(VLSC) からMicrosoft M365 管理センターに変わったため、SQLサーバ2008R2や、2019のボリュームライセンスがダウンロードできない。 弊社のアカウントが現在Microsoft M365と紐づいているが、過去のボリューム ライセンス サービス センター(VLSC) とは結び付いていない。
SQL Server Database Engine
535 questions
asked 2025-12-05T04:57:21.5133333+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(243.2, 94%, 33%)' 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 2025-12-10T05:10:33.08+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
4 answers
One of the answers was accepted by the question author.
SQL License Standard to Enterprise Volume license upgrade
Hi, This is regarding SQL Server licensing. One of our customers procured a SQL Server Standard Edition license about four months ago. Currently, their requirements are not being met with Standard features, and they would like to pay the differential…
SQL Server | Other
14,617 questions
asked 2025-12-09T15:12:40.2866667+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(73.60000000000001, 42%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Balakrishna Medikonda
0
Reputation points
accepted 2025-12-10T03:10:51.16+00:00
Balakrishna Medikonda
0
Reputation points
0 answers
SQL Server 2025 LocalDb installation is missing components
According to https://v4.hkg1.meaqua.org/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…
SQL Server Database Engine
535 questions
asked 2025-12-09T15:15:18.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(236.8, 60%, 32%)' 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)
Duncan Smart
0
Reputation points
commented 2025-12-09T22:41:41.6866667+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator