266 questions
1 answer
unable install sql on on pc due to power shell error
unable install sql on on pc due to power shell error
SQL Server | SQL Server Transact-SQL
asked 2026-02-08T08:45:29.2966667+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, 49%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
pravin bhingardive
0
Reputation points
answered 2026-02-08T08:45:36.74+00:00
Q&A Assist
0 answers
PowerApps SQL Server Connector IP Address Change
The Azure permission drive me insane. Every time you push a button, it opens up a new screen and takes you around in circles. I need to update an IP address for a PowerApps SQL Server connection It's been a couple of years since I've had to make a change…
SQL Server | Other
14,659 questions
asked 2025-01-20T18:11:08.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(67.2, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Al Weedman
0
Reputation points
answered 2026-02-07T21:24:53.7233333+00:00
Aditiya Widodo Putra
85
Reputation points
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
266 questions
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
960
Reputation points
commented 2026-02-07T19:43:34.99+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
0 answers
SQL SERVER (MSSQLSERVER) ERROR 1067
Hola, Tengo un servidor con Windows server 2025 y se le instaló SQL server 2022, se le estaban realizando configuraciones de always on y licenciamiento pero se tuvo que reiniciar. En el momento en que encendió el servidor, el servicio de SQL estaba…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 questions
asked 2026-02-05T19:14:02.0633333+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(105.60000000000001, 33%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
jorge miguel callejas quiroga
0
Reputation points
answered 2026-02-07T13:24:14.14+00:00
Aditiya Widodo Putra
85
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
617 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(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)
1 answer
How to fix missing languages on Full text indexes
Our SQL Server went down after a failed patch `and locked the server instance in ChangePending state, we rolled back the VM and got the DB back to being operational with the exception of the full text indexes... I have run the repair tool checked to see…
SQL Server | Other
14,659 questions
asked 2026-02-06T11:54:35.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(32, 6%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Wade Buckthorp
0
Reputation points
commented 2026-02-06T21:19:23.31+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server 2025 LocalDb installation is missing components
According to https://learn.microsoft.com/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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 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 2026-02-06T21:10:38.19+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
3 answers
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 questions
asked 2025-08-13T13:50:03.2533333+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, 31%, 26%)' 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)
Alex Kipritsis
6
Reputation points
commented 2026-02-06T13:48:55.8166667+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
3 answers
Message=A severe error occurred on the current command. The results, if any, should be discarded.
Hi, There is an Failure in my Azure Datafacttory for a particular table with the below error message. Failure happened on 'Source' side.…
SQL Server | Other
14,659 questions
asked 2026-02-03T06:06:13.4133333+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, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sudhakar Paraniselvan
0
Reputation points
commented 2026-02-06T11:29:52.7466667+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
750
Reputation points Microsoft External Staff
Moderator
2 answers
Power BI Question
I have a table from a SQL server. When I want to see specific data via a visual based on a name I select, it self-filters certain things. My table is called WidgetHistory. The column I want to pull data from is CurrentStatusID. I need to see all widgets…
SQL Server | Other
14,659 questions
asked 2026-02-02T16:31:32.9766667+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, 36%, 33%)' 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)
DukeNukem
0
Reputation points
commented 2026-02-06T11:28:42.75+00:00
Lakshmi Narayana Garikapati
750
Reputation points Microsoft External Staff
Moderator
1 answer
Unable to install SQL server (Setup.exe) Exit code:-2061893606
I am unable to install 2025 SQL server Express Edition. The OOps message pops up at the very end which says: Unable to install SQL server (Setup.exe) Exit code:-2061893606. Wait on the database engine recovery handle failed. Check the error log.
SQL Server | Other
14,659 questions
asked 2026-02-02T14:59:06.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(25.6, 98%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
NGUYEN VINH
0
Reputation points
commented 2026-02-06T11:27:00.3633333+00:00
Lakshmi Narayana Garikapati
750
Reputation points Microsoft External Staff
Moderator
2 answers
Licensing & HA Architecture
My company would like to request official documentation from Microsoft stating that SQL ENT SA (licensed via MPSA) is license-compliant when deployed on our on-premises Huawei private cloud infrastructure. Subject to the above is compliance: If SQL ENT…
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,137 questions
asked 2026-02-05T06:00:03.4533333+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, 41%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dinaish Govindarajoo
30
Reputation points
commented 2026-02-06T10:52:02.44+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,155
Reputation points Microsoft External Staff
Moderator
1 answer
How can I enforce and manage transparent data encryption on SQL Databases involved in replication and Always On AGs?
1.. How can I easily manage TDE -particularly where Database restores to lower environments and between servers is required frequently? 2.How can I manage TDE on Source and Target databases where transactional replication is currently setup?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 questions
asked 2026-02-04T22:53:22.44+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, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOL%3C/text%3E%3C/svg%3E)
Ogunyemi, Lola
0
Reputation points
commented 2026-02-06T09:08:32.4866667+00:00
Akhil Gajavelly
1,155
Reputation points Microsoft External Staff
Moderator
5 answers
How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..
Hi Experts, For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the…
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,137 questions
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,368 questions
SQL Server | Other
14,659 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,773 questions
asked 2023-01-17T12:13:39.11+00:00
Homer Sibayan
366
Reputation points
commented 2026-02-06T05:08:03.4033333+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(76.8, 80%, 17%)' 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)
Shahir Thottathil
1
Reputation point
2 answers
How can I create TRN file to capture only difference daily (between TRN files)?
I am trying to understand how Transaction Log works. This question is related to my previous post. My requirement is, instead of providing BAK file (because it is huge), I am trying to generate one TRN file daily for any change (insert, update or delete)…
SQL Server | SQL Server Transact-SQL
266 questions
asked 2026-02-05T20:07:21.91+00:00
Justin Doh
960
Reputation points
commented 2026-02-05T22:45:16.3466667+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
2 answers
sqlcmd to backup on one server and write to another
I have a sql agent job that runs a CmdExec step on server 'Destination'. It executes a full backup on server 'Source' and needs to write the backup to server 'Destination'. This works perfectly when the server names are hard coded. However, both the…
SQL Server | SQL Server Transact-SQL
266 questions
asked 2026-02-04T23:00:41.0833333+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, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bukkybu
386
Reputation points
recommended 2026-02-05T22:40:12.2866667+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
2 answers
MSDASQL ODBC queries to Linked Servers hang with no response after a couple weeks.
Hi all, Our current setup is a linked server to NetSuite ODBC using MSDASQL 17 as the provider. Everything works and runs fine and fast for about 2 weeks. Then the error will occur. There will be no error message or anything, but the query just…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 questions
asked 2026-02-05T18:29:07.92+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, 40%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Ted
0
Reputation points
answered 2026-02-05T22:35:51.1866667+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
1 answer
Can not install SQL server
I tried to install QL server on my new laptop and seems it's not working at all. Herewith the summary: Summary_TUFA1420250817_20260114_071102.txt I installed using SQL2019-SSEI-Expr, even I tried uninstalled all and tried using SQL2022-SSEI-Expr but…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
617 questions
asked 2026-01-26T15:01:06.8466667+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(224.00000000000003, 57.99999999999999%, 31%)' 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)
Santos
0
Reputation points
commented 2026-02-05T21:42:01.2133333+00:00
Erland Sommarskog
132.1K
Reputation points MVP
Volunteer Moderator
1 answer
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,773 questions
asked 2026-02-05T20:09:28.96+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(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)
Bob-7209
66
Reputation points
answered 2026-02-05T20:09:39.2566667+00:00
Q&A Assist
1 answer
One of the answers was accepted by the question author.
SSIS Job Failing Due to MongoDB Driver Dependency Error After MongoDB 8 Upgrade
As part of an ongoing upgrade to MongoDB version 8, we are updating the C# components used to integrate data into MongoDB collections to ensure compatibility with the latest MongoDB driver syntax and APIs. During this upgrade, we are encountering a…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,773 questions
asked 2026-01-06T15:16:26.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(278.4, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sahar Aitlhou
25
Reputation points
commented 2026-02-05T11:17:43.4566667+00:00
Sahar Aitlhou
25
Reputation points