270 questions
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
![](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, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
980
Reputation points
edited a comment 2026-02-24T19:02:41.1766667+00:00
Justin Doh
980
Reputation points
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2025-09-13T17:06:49.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(275.2, 61%, 36%)' 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)
Salil Singh
60
Reputation points
recommended 2026-02-24T18:38:43.6933333+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
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.
601 questions
asked 2025-10-20T12:51:48.9533333+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, 99%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2025-10-21T08:02:58.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(64, 10%, 16%)' 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)
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
![](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, 33%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
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
14,678 questions
asked 2026-01-29T05:19:45.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(16, 36%, 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
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2026-01-29T03:51:41.4333333+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, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
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
![](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, 48%, 16%)' 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)
Máté Gribovszki
0
Reputation points
recommended 2026-02-24T18:36:05.9433333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
I have installed SSMS 2022 but unable to login.
Hello Team, I have installed SSMS 2022 on my local laptop. But I am unable to connect to the connection string. My laptop server name is ASHISH and instance name is MSSQLSERVER. I am entering ASHISH\MSSQLSERVER as Server Name but it is showing error code…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2026-01-19T09:20:08.8366667+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, 89%, 19%)' 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)
Ashish Karnavat
0
Reputation points
recommended 2026-02-24T18:35:26.6333333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
Applying token authentication to read data from a ZenDesk source in a SSIS 2022 package
Hi, I need to maintain an existing SSIS 2022 package that performs an API call to a ZenDesk source by the removed username and password authentication method, changing this authentication type to token one. Unfortunately, I don't know ZenDesk and I have…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,777 questions
asked 2026-01-17T17:04:53.8533333+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(115.19999999999999, 41%, 21%)' 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)
pmscorca
1,052
Reputation points
recommended 2026-02-24T18:35:08.71+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Microsoft SQL Server 2025 availability on CSP
When will Microsoft SQL Server 2025 be available on CSP and does it come with PBIRS Functionalities and Software Assurance
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,777 questions
asked 2025-12-09T16:01:41.5366667+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, 7.000000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nurudeen Adeboye
21
Reputation points
recommended 2026-02-24T18:34:20.3833333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SSRS Report Credential Error
SSRS report works initially but fails after 10–15 minutes of idle time. When user clicks Next page, Print, or Download, the report throws error: "Credentials have not been supplied for a data source used by the report." The report is generated…
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-09T08:20:00.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(278.4, 78%, 36%)' 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)
Raju Kothapally
10
Reputation points
recommended 2026-02-24T18:33:55.25+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
PBIRS error when creating a scheduled refresh
PBIRS 15.0.1118.126 Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 2026-01-12 10:50:43.3169|ERROR|54|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred…
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-12T06:25:05.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(134.4, 52%, 23%)' 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-02-24T18:33:18.6866667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Microsoft ODBC Driver for SQL Server Version 17.10.000
Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed" Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2025-08-14T13:52:40.3733333+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, 9%, 26%)' 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)
Armando D. Hernandez
5
Reputation points
recommended 2026-02-24T18:32:50.8+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
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
14,678 questions
asked 2026-02-24T15:24:35.8666667+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, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jim
386
Reputation points
edited the question 2026-02-24T15:58:40.57+00:00
Mike Bowen
2,056
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
I used to have an azure sql db 2 years ago, but now I can find no record of it. Is there any way that Azure support could look and see if they can restore it?
SQL Server | Other
14,678 questions
asked 2026-02-24T14:52:39.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(176, 26%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Benjamin Hefner
20
Reputation points
accepted 2026-02-24T15:29:27.2033333+00:00
Benjamin Hefner
20
Reputation points
2 answers
One of the answers was accepted by the question author.
A Scalar UDF works consistently in SQL Server 2017, fails sporadically under 2019 and 2022.
You can try this at home! I use this udf to capture the number of cores available when my stored procedure runs in cloud. But, since I develop against my local on-prem database, I coded it to return a -1 when it's not running in the cloud. Here's the…
SQL Server | SQL Server Transact-SQL
270 questions
asked 2026-02-23T22:52:16.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(144, 22%, 23%)' 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)
Steve Grimes
20
Reputation points
commented 2026-02-24T14:55:33.2633333+00:00
Steve Grimes
20
Reputation points
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 questions
asked 2026-02-21T13:32:24.1533333+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(121.6, 86%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Abdelrahman Hany
0
Reputation points
commented 2026-02-24T13:47:34.6666667+00:00
Abdelrahman Hany
0
Reputation points
2 answers
SSIS Data Flow has trouble when it has to return many fields
I have an SSIS project that calls stored procedures to create extract files via OLE DB Source & Flat File Destination. The stored procedure returns 150 fields and sometimes a few million records. This causes SSIS & Visual Studio 2019 to take a…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,777 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(38.4, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB7%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
645 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,456
Reputation points
accepted 2026-02-24T12:38:04.3133333+00:00
Greg Booth
1,456
Reputation points