SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
2 answers
MSSQL prefer way to transfer big file from server to client.
Hello I have a cpp client which connects to MSSQL server 2025 using ODBC or Native client. I need to transfer large number of files (can vary from 100 MB to 1GB there can be many files from 1 to 100) what is best way to transfer such large amount of data…
SQL Server Database Engine
asked 2026-05-29T09:44:03.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(156.8, 19%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vivek Mendse (vmendse)
0
Reputation points
answered 2026-05-29T12:28:36.1+00:00
Erland Sommarskog
134.3K
Reputation points MVP
Volunteer Moderator
2 answers
Questions regarding the details of differential backup
According to the online documentation, differential backup determines whether a sector has changed. I have the following two questions: Is it possible that within a single sector, 1 page belongs to SQL Server and 7 pages belong to other application files…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
asked 2026-05-29T08:21:10.9233333+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, 66%, 20%)' 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)
博雄 胡
745
Reputation points
answered 2026-05-29T12:11:56.2933333+00:00
Erland Sommarskog
134.3K
Reputation points MVP
Volunteer Moderator
3 answers
Kerberos fails on AG Listener — only from cluster nodes, ticket not generated
Environment: SQL Server Always On AG on top of FCI, Windows Server cluster, domain-joined nodes. Problem: Connections to the AG listener always fall back to NTLM, but only when connecting from the cluster nodes themselves. From any other machine on the…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 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(83.2, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
Confirmation on Maintenance Plan DLL Usage for SQL Server 2025
Hello Team, Earlier, till SQL Server 2022 (version up to 16) we were compiling our Maintenance Plan source code project by referencing the required DLLs from the GAC. However, for SQL Server 2025 (version 17), based on our analysis of the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,792 questions
asked 2026-05-25T14:13:00.8+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, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
20
Reputation points
commented 2026-05-29T10:49:27.2066667+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,315
Reputation points Microsoft External Staff
Moderator
2 answers
Why is SQL AO-AG slower to failover than SQL Mirroring
Encountered problem: Our use-case has 3 x Server 2022 in a topology of a domain controller with two node cluster. This is a SQL Always On AG architecture. The cluster hosts the SQL availability group roles. This is a replacement for the MS deprecated SQL…
Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 questions
asked 2024-03-08T16:31:28.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(128, 8%, 22%)' 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)
Anonymous
commented 2026-05-29T09:13:11.97+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, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENE%3C/text%3E%3C/svg%3E)
Niklas Engfelt
21
Reputation points Microsoft Employee
1 answer
set date range to all records on dates parameters
I want to set my date range in parameters to all dates. how can I do that in parameters settings
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,162 questions
asked 2026-05-28T19:10:12.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(201.6, 24%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
Victor Hache
0
Reputation points
commented 2026-05-28T20:10:12.4466667+00:00
Erland Sommarskog
134.3K
Reputation points MVP
Volunteer Moderator
4 answers
Cannot add users or groups in report server portal
The problem is that I cannot set the users or groups after adding the custom security.
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,162 questions
asked 2022-07-25T05:39:09.167+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, 10%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
PATRICK WONG ZHEN HONG
1
Reputation point
answered 2026-05-28T15:28:15.2633333+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, 95%, 37%)' 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)
Avinash G
0
Reputation points
1 answer
Performance Degradation after moving from SQL 2019 to SQL 2025
I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
asked 2026-05-07T17:39:23.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(240, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mantini, Ronald M
6
Reputation points
commented 2026-05-28T15:26:11.38+00:00
Erland Sommarskog
134.3K
Reputation points MVP
Volunteer Moderator
1 answer
NOT BEING ABLE TO INSTALL SQL SERVER IN MY DEVICE
I can't insatall SQL SERVER 2025 , tried all the version and failed on every please help me !!!
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 questions
asked 2026-03-29T11:33:41.1366667+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(265.6, 32%, 35%)' 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)
Arpit Sharma
0
Reputation points
commented 2026-05-28T15:24:58.0833333+00:00
Arpit Sharma
0
Reputation points
3 answers
locking issue in MSSQL
Issue: the holdlock script has locking the multi-thread(10) insert/update We would like to revise the multi-thread script to from (HOLDLOCK) to (UPDLOCK, SERIALIZABLE) Original script: MERGE testtable WITH (HOLDLOCK) AS t USING (SELECT @P0 hjmpTS, @P1…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
asked 2026-05-20T07:28:48.0066667+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, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sam Chung
0
Reputation points
commented 2026-05-28T12:16:00.1333333+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
2 answers
We need to retrieve a SQL 2019 key
We purchased SQL 2019 Standard in 2022 from First Technology Group in South Africa (DG7GMGF0FKX90003). We have recently lost our server after a violent storm resulting in a power surge and now need to re-install SQL 2019 on a new server. We contacted…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 questions
asked 2026-05-17T11:16:50.7766667+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, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Charmaine Lindsay
0
Reputation points
commented 2026-05-28T12:14:48.46+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
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,743 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-05-28T12:13:59.3266667+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server 2022 Express installation error -2061893606 and service error 1067
Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
asked 2026-05-14T10:18:59.6533333+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(172.8, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Youssef Maach
0
Reputation points
commented 2026-05-28T06:35:30.5+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,825
Reputation points Microsoft External Staff
Moderator
1 answer
How to see the daily sales of division 115P in SQL Server Reporting Service?
The PIDV 115P is no longer displayed in SQL Server Reporting Service Link: [http://w1892/Reports_PROD2/report/Demand%20Chain/Shipments_from_Factory_Warehouse] Can you enter it again? Or now where can I see the daily sales of division 115p?
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,162 questions
asked 2026-05-13T18:17:50.9233333+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(0, 22%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Leslie Rosario Hernandez
0
Reputation points
commented 2026-05-28T06:34:28.35+00:00
Akhil Gajavelly
1,825
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,743 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
commented 2026-05-28T06:33:33.94+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
2 answers
SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)
I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,792 questions
asked 2026-04-29T06:12:42.41+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, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
Ishika Raiyani
20
Reputation points
commented 2026-05-28T06:18:53.4833333+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered
Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
283 questions
asked 2026-04-28T02:03:11.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(185.6, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Michelle
0
Reputation points
commented 2026-05-28T05:35:45.2133333+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
3 answers
getting below error while installing microsoft sql server 2025
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
712 questions
asked 2026-05-25T16:59:03.3033333+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(172.8, 69%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Manisha Shinde
0
Reputation points
commented 2026-05-28T04:40:59.2966667+00:00
Akhil Gajavelly
1,825
Reputation points Microsoft External Staff
Moderator
1 answer
Asset KPI's didnt calculated
Some of the asset KPI's can not be calculated, help me find the problem and solution
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,162 questions
asked 2026-05-28T01:34:07.9833333+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(22.400000000000002, 73%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Fakhrudin Ahmad
0
Reputation points
commented 2026-05-28T01:38:08.9233333+00:00
Fakhrudin Ahmad
0
Reputation points
1 answer
Unable to connect anymore to SQL Server..
I used SQL last year for sometime just fine, then recently this month tried getting back to it & suddenly it doesn't work. I might have deleted some files by accident so I uninstalled everything SQL related & installed again. Still not connecting…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 questions
asked 2025-01-23T23:05:50.4266667+00:00
Anonymous
answered 2026-05-27T23:16:48.0533333+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(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
0
Reputation points